How detect when all queries have been refreshed in VBA

[nando88]

I need to run some VBA Code after all my quesries have been refreshed, but I don't know how.
Can someone please tell me how to detect if all quesries have been refreshed, through VBA?
Any help will be greatly appreciated.
Thanks in advance.

 

[Jaafar Tribak]

Do a search on AfterRefresh

 

[nando88]

Do a search on AfterRefreshI found the code for the event in this site, but I don't know where should I place the code?

How to call macro after Refresh or Refresh All button pressed?

Ultimately, I would like to run a macro after anyone refreshes the workbook, specifically using the Refresh button under the Data tab in Excel. For the time being, I would be satisfied just gettin...

stackoverflow.com

 

[Jaafar Tribak]

How to call macro after Refresh or Refresh All button pressed?

Ultimately, I would like to run a macro after anyone refreshes the workbook, specifically using the Refresh button under the Data tab in Excel. For the time being, I would be satisfied just gettin...

stackoverflow.com

Place the event code in a class module ... It is all explained in the linked stackoverflow page.

 

[John_w]

See also this solution by @Domenic:

Run VBA after ALL tables have refreshed

I want to have a block of VBA code run after all the tables in the workbook have refreshed: User clicks the Refresh All button which causes All tables in the workbook to be refreshed four tables, each on a separate sheet tables are refreshed via Power Query Once all tables have completed the...

www.mrexcel.com