HI all,

I have the following case:
I have several excel files, which contain pivot tables. These files need to be refreshed regularly. I do not want to do it manually, so I created a code in a separate file.
The code shoule open each of the specified excel, rehresh the pivot table, save and close.
The interesting part is open file not a problem, then the code is:
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close

If you debug step by step all is fine, but if you run the code you get an error between RefreshAll and Save. Reason: The Save command is executed WHILE the pivt table is still refreshing and this generates an error, whereas if you allow the rferhesh t complete, no error.
So, is there a way to tell the system to wait until refrehs is complete, before moving to the Save command?