Results 1 to 2 of 2
  1. 01-14-2013, 05:08 PM #1
    ragsgold
    ragsgold is offline Access & Excel Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2009
    Location
    Denver,CO
    Posts
    51

    Thumbs up RunCommand - PivotTableExportToExcel

    Hi



    I have a select query where I had created a pivot table view with specific rows and columns. I am trying to use RunCommand / PivotTableExportToExcel option in Macros to export the pivot table as is from access to an Excel ....

    can you suggest parameters cant find anything in the help
    Reply With Quote Reply With Quote
  2. 01-14-2013, 06:43 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Google: Access export pivot table
    Does this help:
    http://social.msdn.microsoft.com/Forums/sk/isvvba/thread/31f76977-4571-4dac-a9a1-0bc7327202c6
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Access RunTime 2010 security settings - "The RunCommand action was canceled"
    By dblaron419 in forum Access
    Replies: 3
    Last Post: 07-19-2012, 06:22 AM
  2. RunCommand acCmdSaveRecord
    By apotter in forum Programming
    Replies: 1
    Last Post: 03-26-2012, 11:46 PM
  3. Error 2001 on Docmd.RunCommand (accmdInsertObject)
    By VICTOR HUGO in forum Forms
    Replies: 0
    Last Post: 06-17-2010, 04:51 AM
  4. DoCmd.RunCommand acCmdSaveRecord
    By Rick West in forum Programming
    Replies: 3
    Last Post: 04-22-2010, 02:52 PM
  5. Run-time Error '2046' when using DoCmd.RunCommand acCmdCopy whilst browsing records
    By cbazchin in forum Programming
    Replies: 5
    Last Post: 03-30-2010, 12:53 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums