Need to run multiple Queries

[DomP]

I have a number of queries that I need to run at once. Not sure if this is doable and/or the best way to accomplish this. The queries are independant of each other and have no relationship other than having to run one after the other. Bascially they are separate extracts that need to run to create separate .xls files.

Thanks,

Dom

 

[lespaul]

easiest way is to set up a macro to run them.

next suggestion, use a module.



Leslie

 

[DomP]

Leslie,

I'm in the desgin screen of the macro and I can figure out how to run 1. But how do I setup to run 1 thuu 99?

Thanks,

Dom