Rook

You can delay it by running some other dummy code using

Application.OnTime

Placing something like

Application.OnTime Now + TimeValue("00:00:15"), "DummyProcedure"

Will hold the file open for 15 seconds waiting for it to run
'DummyProcedure'

That sub could just be

Sub DummyProcedure()
Msgbox "Data Refreshed"
End Sub

--

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?