RefreshAll complete event

[chungtinhlak]

Hi all, I have a workbook that I use refreshall on. It takes 30 seconds to couple minutes depending on the time of date we use it. I want to have a popup to tell people that it's complete but vba doesn't wait for it to complete, the box comes up immediately.

The questions is, what is the easiest way to capture that my refreshall is complete.

thank you so much

[Aflatoon]

The simplest method is to not use Refreshall but refresh your queries individually and specify backgroundquery:=false in the code, or set that in the connection properties.