Save PivotChart as image

[james_halliwell]

Hi,

after extensive googling im still struggling an hoping someone can help me out

I have a query that has a pivot chart, i need to be able to svae this as an image so i can insert it into a html email but i cannot find anything, im using access 2010

Please can someone help me out

Many thanks

 

[pr2-eugin]

I have a method where you can Print Screen into Image file.

You could use the same, where the pivot chart is displayed, you can take a screen capture and save it to disk and then use that path to email. Simples.

 

[pr2-eugin]

Did a simple Google search there are plenty of resource of saving files. This one seems to be a good one. http://peltiertech.com/WordPress/export-chart-as-image-file/

 

[vbaInet]

If the query's Default View is set as Pivot Chart you should be able to use DoCmd.OutputTo to save it as a pdf file.