VB coding

[Guest]

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.

 

[Don Guillett]

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