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".