Results 1 to 3 of 3
  1. #1
    Chatholo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    34

    Export Report to existing workbook with multiple new tabs in excel

    Hi there,



    I am failry new to access and have some challenges with exporting a report. I read a few threads but have no idea/understanding on how to use the coding.

    I have a report that I would like to export in an existing workbook but want to create new tabs for each one of my 1st group in my report
    eg: Product | business unit | country | Number | are my columns and I want a tab in excel by product.

    Thank you for your help!
    C.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Chatholo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    34
    Thanks June7. I have looked at all the threads to try to sort this out but I am too new at coding to understand how to use the information and where to update names for my owns. I am NOT giving up though! I keep working on my database!
    Just wanted to thank you for replying to my post
    C.

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

Similar Threads

  1. export quety result to existing excel workbook
    By jsimha in forum Import/Export Data
    Replies: 1
    Last Post: 01-19-2013, 06:49 AM
  2. Replies: 12
    Last Post: 12-17-2012, 12:47 PM
  3. export query into existing workbook
    By hklein in forum Programming
    Replies: 3
    Last Post: 05-08-2012, 04:55 AM
  4. Exporting Query Results to an existing Excel Workbook
    By Dnphm in forum Import/Export Data
    Replies: 3
    Last Post: 07-13-2010, 11:40 AM
  5. export report to multiple tabs
    By mws5872 in forum Import/Export Data
    Replies: 0
    Last Post: 06-30-2009, 03:07 PM

Tags for this Thread

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