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