?
Solved

Export from Access to Multiple Excel Sheets

Posted on 2011-02-13
4
Medium Priority
?
495 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:vsllc
  • 2
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34885460
0
 

Author Comment

by:vsllc
ID: 34885522
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34885531
you will need the codes from this link

http://www.lebans.com/callbackbrowser.htm
0
 

Author Comment

by:vsllc
ID: 35118608
Perfect!  Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question