Removing Access External Data Queries from Excel
 

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

Removing Access External Data Queries from Excel
 

With external queries to yahoo finance, etc I delete the names in
insertnamedefine.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Michael Kintner" wrote in message
...
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