pausing vba for refresh
In the absence of seeing any code it is hard to give a definitive answer but
you could try using DoEvents
--
HTH...
Jim Thomlinson
"westg" wrote:
I setup a query on an sql db. However I need the vba to pause while the query
refreshes and brings the data into Excel.
So far I have tried using
Application.Wait Now + TimeSerial(0, 0, 10)
However if a user is daft enough to run a query on huge amount of data, i am
screwed.
is there a way of pausing until the data has finished refreshing?
Many thanks, Andrew
|