Results 1 to 3 of 3
  1. #1
    ketangarg86 is offline Novice
    Windows 8 Access 2013
    Join Date
    Sep 2014
    Posts
    24

    Button VBA to export data from Access to multiple sheets in same excel workbook

    Hi,

    I have an access query with around 10 columns. One of the columns is city. There are total of 5 unique cities. I need a macro for the button in the access report that will export the data from the access query to the ONE excel workbook in such a way that each city filtered data from access is exported to city name worksheet. So Excel file would have in total of 5 worksheets with the relevant city data.

    Please help..

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I have never used a button on a report, only on forms.....

    But Ken Snell has info on exporting to Excel at http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

  3. #3
    ketangarg86 is offline Novice
    Windows 8 Access 2013
    Join Date
    Sep 2014
    Posts
    24
    Tried this "Create a Query and Export multiple "filtered" versions of a Query (based on data in another table) to separate Worksheets within one EXCEL file via TransferSpreadsheet (VBA)" from the link you posted but still not working.

    I am new to VBA..is there some other link where it is explained for a newbie like me..

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-16-2013, 07:43 PM
  2. Replies: 12
    Last Post: 12-17-2012, 12:47 PM
  3. Replies: 1
    Last Post: 08-25-2012, 06:11 PM
  4. Replies: 2
    Last Post: 08-14-2012, 04:24 AM
  5. Exporting Queries to Excel Sheets, 1 Student per Workbook
    By StudentTeacher in forum Programming
    Replies: 8
    Last Post: 09-02-2010, 11:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums