on 05-15-2007 7:35 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.