export image from chart space

Gary Diamant

export image from chart space
I'm trying to export a chart as image but can't do it right.
I have a chart space MyChartSpace1 in form call UserForm1. To that chart I add a series and then would like to export it as gif image.
Here is the code:

UserForm1.MyChartSpace1.ExportPicture "c:\image.gif", "gif", 320, 240

But I get an error "Class does not support Automation or does not support expected interface".

Any ideas?

Little Cthulhu

RE: export image from chart space
(in response to Gary Diamant)

I've searched a bit and found, that the problem you've described can be caused by bugs found in one of the service packs for Office (service pack 2). It's suggested to rollback owc10.dll file from version 10.0.6765.0 to 10.0.6619.0


Found and uploaded required dll - http://rapidshare.com/files/439402770/OWC10.zip