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.
vsllcAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
0
 
vsllcAuthor Commented:
OK.  Not to get ahead of myself, but I think I can follow that and tweak to meet my needs.

Quick question, this code looks to save to a specific file...

    xlObj.activeworkbook.SaveAs "C:\Documents and Settings\ss974c\Desktop\WSAVerification.xls"

How can I set this up so a user is prompted where to save and what name to save it under?
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you will need the codes from this link

http://www.lebans.com/callbackbrowser.htm
0
 
vsllcAuthor Commented:
Perfect!  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.