brendanolear
Active Member
- Joined
- Apr 26, 2008
- Messages
- 366
I am working in Access 2010.
I have some 20 Select queries in my Access DB. Queries are named GBQuery01, GBQuery02, GBQuery03 etc.
I wish to be be able to use VBA to run GBQuery01, then export the result to an Excel 2010 file, this would be a newly created file titled GBQuery01.xlsx.
I would then wish to move on to GBQuery02, run, export etc across all 20 queries.
The end result would be 20 newly created xlsx files.
Can anyone assist with a VBA coding to meet this requirement.
Thanks in advance.
I have some 20 Select queries in my Access DB. Queries are named GBQuery01, GBQuery02, GBQuery03 etc.
I wish to be be able to use VBA to run GBQuery01, then export the result to an Excel 2010 file, this would be a newly created file titled GBQuery01.xlsx.
I would then wish to move on to GBQuery02, run, export etc across all 20 queries.
The end result would be 20 newly created xlsx files.
Can anyone assist with a VBA coding to meet this requirement.
Thanks in advance.