By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,068 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,068 IT Pros & Developers. It's quick & easy.

Error Using the Export Picture Method

P: 32
Good afternoon,

Can someone please assist me with getting over this error. I am trying to export a chartspace as a gif image. I keep getting runtime error 430- Class does not support Automation or does not support expected interface.

This is lines of code that i am using

Dim objChartSpace As OWC10.ChartSpace

Set frm = Forms("frmPivotChart")

Set objChartSpace = frm.ChartSpace
objChartSpace.Clear
objChartSpace.Charts.Add
Set objPivotChart = objChartSpace.Charts.Item(0)

objChartSpace.ExportPicture "D:\My Documents\My Pictures\chart1.gif", "gif", 320, 240

Can someone please help me get over this runtime error??

Thanks,
Jul 25 '07 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Good afternoon,

Can someone please assist me with getting over this error. I am trying to export a chartspace as a gif image. I keep getting runtime error 430- Class does not support Automation or does not support expected interface.

This is lines of code that i am using

Dim objChartSpace As OWC10.ChartSpace

Set frm = Forms("frmPivotChart")

Set objChartSpace = frm.ChartSpace
objChartSpace.Clear
objChartSpace.Charts.Add
Set objPivotChart = objChartSpace.Charts.Item(0)

objChartSpace.ExportPicture "D:\My Documents\My Pictures\chart1.gif", "gif", 320, 240

Can someone please help me get over this runtime error??

Thanks,

Hi, there.

Object variable objChartSpace is declared as OWC10.ChartSpace. Then you try to set it to object being returned by Form.ChartSpace property.
Do you mean an OWC chart form control or ChartSpace property of the form itself?
Aug 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.