Saving PivotChart Image?

[davem99]

I can't believe this is so tough!!

OK....I have a pivotchart form that is a subform on another form.

I can't get the exportpicture method to work.
This is the code I'm using....

Set chart = Me.HomeSales.Form.ChartSpace
chart.ExportPicture "C:\blahblah.jpg"

Has anyone got this to work?

thanks!

 

[kjv1611]

Try taking a look at this:
[URL unfurl="true"]http://answers.google.com/answers/threadview?id=715733[/url]

 

[davem99]

Been there, done that.

I believe that works with v10 of the DLL but craps out with v11.

You get either a type mismatch or and automation error

 

[davem99]

Re-posting......I'm sure someone somewhere has done this!

Any help appreciated!