copy Pivot Chart in access and paste in word

  • Thread starter Thread starter punki van via AccessMonster.com
  • Start date Start date
P

punki van via AccessMonster.com

Is there any way to copy a pivot chart in access and paste in word or power point?

Thank you
 
punki said:
Is there any way to copy a pivot chart in access and paste in word or power point?

Thank you
Click to expand...

Not easily, but it can be done via code. Follow this link to
office.microsoft.com:

http://office.microsoft.com/en-us/assistance/HA010345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne
 
Leanne, my understanding is that the "me" operator only works with the forms
collection. I am trying to do the run a similiar piece of code (as mentioned
in your link) but in does not work in my case -- where I am directly from a
query to create the pivotchart, then using a mcaros on my tool bar I try to
export to a gif. I am making no progress since I don't seem to be able to
reference the active/current pivotchart. Any help would be greatly
appreciated.
 
Back
Top