Dugantrain
I Love Pants
- Local time
- Today, 18:03
- Joined
- Mar 28, 2002
- Messages
- 221
Hi, I'm looking to do the following in the On-Click event of a command button:
And Then:
So, basically, I'm looking to export several queries to the same worksheet. However, I get errors when attempting to do so, when I try to export the second query, Access says that the query already exists. How can I get around this and have it export multiple queries to the same worksheet (and eventually have multiple queries paste to different worksheets within the same workbook?)
Code:
DoCmd.TransferSpreadsheet
acexport, , "Some_Query", "Some_FileName",
False, "Some_Range"
And Then:
Code:
DoCmd.TransferSpreadsheet
acexport, , "Different_Query", "Same_FileName",
False, "Different_Range"
So, basically, I'm looking to export several queries to the same worksheet. However, I get errors when attempting to do so, when I try to export the second query, Access says that the query already exists. How can I get around this and have it export multiple queries to the same worksheet (and eventually have multiple queries paste to different worksheets within the same workbook?)
Last edited: