copy Pivot Chart in access and paste in word

[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

 

[LeAnne]

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

Thank you

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

 

[Guest]

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.