VB coding
 

I need to create a macro that opens an excel file, will click on "enable
automatic refresh," process the webqueries, and than save and close the file.
The issue with the recording of the macro is that it will open the file
however it will not recognize the query refresh option.

VB coding
 

try something like
for each q in thisworkbook.querytables
q.refresh
next q

--
Don Guillett
SalesAid Software

"ndn14" wrote in message
...
I need to create a macro that opens an excel file, will click on "enable
automatic refresh," process the webqueries, and than save and close the
file.
The issue with the recording of the macro is that it will open the file
however it will not recognize the query refresh option.