I still didn't work. When I open the other workbook I am asked to enable the
automatic refresh, but when I try to record a macro and look back to see what
was created by the recording I don't see the automatic refresh addressed.

"Nick Hodge" wrote:

Rook

Let me know if that works, because the code may not stop still on a data
connection but I can't test

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"rook" wrote in message
...
I was trying to use a macro to open a workbook that contains a web query
and
then save and close the workbook. However, when I run the query the
workbook
closes before the web query is run so the data isn't updated. How can I
delay the macro to allow the query to run correctly?