Hi,
i have a workbook which needs to be updated from the external source, and the process looks like this:
1. I go to add-in tab and press "refresh"
2. then the wizard opens, I select the date needed, and the refresh begins, there is a message box with "please wait" in it.
3. Once the data is refreshed, the wizard closes.

After that I need to process the data, rearrange it and refresh the pivot table. I have written a macro for this, and i would like to couple refresh and rearrange actions into one macro, but i have a problem, that the macro does not know when the refresh of data is complete. The refreshing takes a few minutes, and the duration is not always the same, so i cannot pause the macro for a certain period of time.

Maybe there is another way, for macro to somehow detect, that the refresh wizard (message with "please wait") is closed and only then continue?