Removing Access External Data Queries from Excel

[Michael Kintner]

Hello Folks,

I have a Excel Spreadsheet with Microsoft Access external data query links.
I would like to create a snapshot in time of the data in the Excel
Spreadsheet. I do this now by manually going to each external data query
cell (there are 8 of them), right click the cell, select Data Range
Properties, then uncheck the Save Query Definition, it asks me to confirm
and press OK. Now the external link is disconnected saving the last data
query value in the cell.

The interesting thing here is when I try to record via the excel macro
recorder nothing shows up in the macro recorder vb code.

Doesn anybody have a method to turn off all external data links via
programming?

Thank you in advance,
Mike

 

[Don Guillett]

With external queries to yahoo finance, etc I delete the names in
insert>name>define.

for each n in sheets("sheet1")
n.delete
next