ActiveWorkbook.RefreshAll waiting time
 

Hi all!

I'm working with Excel 2007 and using the data connection function to
connect to a SQL server as a source...

I'm woking on a VBA code that have to update the connection and
perform some calculation on the data....

unfortunately, the updating process (ActiveWorkbook.RefreshAll) is not
finished when the code is performng the calculation...

it is possble to insert a "waiting time" after the
ActiveWorkbook.RefreshAll ????

any other suggetion???

thanks all

cheers

Vit

ActiveWorkbook.RefreshAll waiting time
 

You could try the one-liner
DoEvents
or - for 10 seconds -
Application.Wait Now + TimeValue("00:00:10")

ActiveWorkbook.RefreshAll waiting time
 

Thanks for your replay, I have understod the Application.wait Now +
TimeValue("00:00:10")

but how can I be sure that the update process is finished???

what about DoEvent??? how does it work???

thank you so much....
vit



On Nov 17, 8:24*pm, wrote:
You could try the one-liner
DoEvents
or - for 10 seconds -
Application.Wait Now + TimeValue("00:00:10")