Run multiple queries in workbook before vba code

[Former Member]

Hi All,

I have a workbook with 2 queries, one on each tab that I need to run, then run some VBA code over both sheets. The issue I have is the VBA code is running after the first query finishes, not after both have finished.

Can anyone suggest a way of ensuring both queries finish before the VBA code starts?

Thanks for all assistance

[Former Member · Accepted solution]

Stuart,

Just put a button in the workbook, where the VBA code will get executed once the button is pressed after the report is refreshed.

[Former Member]

Thanks for your suggestion, the simplest ways are usually the best!

I was trying to find an automatic way but this works fine.

Thanks again.