Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Location
    Firenze
    Posts
    1

    Exporting pivot table

    Hi,


    is there vba code to obtain the same result that “Export to Excel” button on ribbon/toolbar access menu?
    I tried to use DoCmd.OutputTo command but only data refer to recordsource control
    was export in excel file.
    I mean there is a difference between the action that the "Export to Excel" execute from the action that
    execute the use of DoCmd.OutPutTo

    thanks for advice

  2. #2
    Join Date
    Apr 2008
    Posts
    1
    I am having the same problem. I ran across your post while searching for a solution. Although I have not gone in and looked at the VBA myself yet there is a sample database online at http://www.rogersaccesslibrary.com/O...Table.mdb' that successfully does it. I am going to go in and take a look for myself and hopefully find how they did it. Hope the same works for you.

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

Similar Threads

  1. Exporting a Switchboard
    By Hawkx1 in forum Forms
    Replies: 1
    Last Post: 07-08-2008, 06:59 AM
  2. Pivot Charts
    By Ruby in forum Access
    Replies: 0
    Last Post: 11-16-2007, 05:56 PM
  3. Exporting main table AND subform
    By jenny28 in forum Import/Export Data
    Replies: 0
    Last Post: 05-10-2007, 11:40 AM
  4. Pivot Table Problem
    By larpup in forum Forms
    Replies: 0
    Last Post: 01-06-2006, 08:11 PM
  5. pivot table totals
    By brian12pme in forum Forms
    Replies: 0
    Last Post: 12-07-2005, 03:34 PM

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