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

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Michael Kintner" <michaelkintner@nospam.com> wrote in message
news:13kr337qacipn26@corp.supernews.com...
> 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
>