Results 1 to 2 of 2
  1. #1
    Tomlon is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    7

    Access 2010 VBA Creating Pivot Table in Excel

    I have a query (qry123) that I have a pivot table form based off. I need VBA that will export this query to Excel. This is not the issue, I can use DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "YTD Data", strFilePath, True command and expor tthis query to a new Excel workbook. What I need is to have code that will change this raw data into a pivot table. Again, this needs to be done from Access.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You have solved this issue?

    This thread https://www.accessforums.net/program...ing-32297.html indicates you are able to code the pivot tables.
    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.

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

Similar Threads

  1. Creating a pivot table like query
    By razkowski in forum Queries
    Replies: 2
    Last Post: 07-03-2012, 09:45 AM
  2. Creating Excel pivot table issue
    By Reaper in forum Import/Export Data
    Replies: 1
    Last Post: 06-14-2012, 12:32 PM
  3. Export to Excel from Pivot Table in Access 2010
    By nicon2k in forum Import/Export Data
    Replies: 0
    Last Post: 04-10-2012, 07:02 AM
  4. Pivot table - access to excel
    By antagonia in forum Access
    Replies: 3
    Last Post: 12-16-2011, 01:57 PM
  5. Export Access Pivot Table to Excel
    By graviz in forum Programming
    Replies: 1
    Last Post: 11-13-2009, 07:30 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