vsllc
asked on
Export from Access to Multiple Excel Sheets
I can successfully export a table/qry from Access to Excel using ransferspreadsheet. I would like to take this another step and, when exporting a table, create a seperate sheet for every account that it is in the table. The number of accounts can fluctuate in the table (which is created by a qry). I would also like the sheet names to be the name of the account. Is this possible? I currently just overwirte the existing Excel workbook, but it would nice if I could choose to save this file when run instead of always overwriting the file and then opening/saving somewhere else.
Thanks in advance.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks.
ASKER
Quick question, this code looks to save to a specific file...
xlObj.activeworkbook.SaveA
How can I set this up so a user is prompted where to save and what name to save it under?