Macro to run multiple queries

Hi,

I have a spreadsheet that has individual queries that are each on a separate worksheet. Each worksheet has the following code belowto automatically connect and run the query and return results to the worksheet. Since there are over 60 queries, I would like to be able to just click one button to run all queries. They have to run individually, so I am unsure how to write anything that would tell it to run the next query when the previous one finishes.

Any help would be greatly appreciated, thanks

Please Login or Register  to view this content.

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)

Suggest you try this on a backup copy of your workbook

Instead of having the same macro 60 times I suggest 1 macro that loops through each worksheet & calls the 1 macro that is re-written to work with each sheet

Please Login or Register  to view this content.

It is possibel that the code you posted will work correctly if you paste a copy in a normal module & delete all others copies of the macro