Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    2

    Unanswered: Export MS Access Pivotchart

    Hi everyone,
    I have MS Access queries and forms tied to those queries. The forms
    are set to be viewable only as PivotCharts. I cannot figure out how to get these pivotcharts out of MS access
    while maintaining the pivotchart formatting - other than taking
    screenshots one at a time and pasting into word or similar!
    I know access fairly well. I don't know VBA at all. I found the
    "answer" to this problem here:

    http://office.microsoft.com/en-us/as...345791033.aspx,
    but it doesn't work
    Help me pls

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    What exactly did you do with the answer you found on the Microsoft site?

    I looked through it really quickly and they tell you step-by-step what to do.

    Exporting the pivot chart to MS Excel:

    Code:
    Me.PivotTable.Export "Your File Name Here", plExportActionOpenInExcel
    Export the pivot chart as Image:

    Code:
    Me.PivotTable.ExportPicture "C:\yourdirectory\filename.gif", , 1024, 1024
    where 1024x1024 is the size of the image.

    if you upload your db and tell use what chart you're trying to export and the file type you're trying to export to, maybe we can help a little more.

  3. #3
    Join Date
    Jun 2007
    Posts
    2
    http://ichoo.hit.bg/icho.mdb
    That is my database, appreciate your help, really

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •