How do I avoid Error 430 with OWC ChartSpace ExportPicture?

[Pat Finegan]

I have an OWC 11 ChartSpace on a UserForm. I would like to use the
ExportPicture method but receive Error 430 instead: "Class does not support
Automation or does not support expected interface." I have tried adding the
ChartSpace at run time and at design time. I have followed the example in the
documentation verbatim. The method simply does not work.

Suggestions?

 

[Alvin Bruney - MVP ASP.NET]

what version are you working with? Try re-registering that version at the
command prompt.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[Pat Finegan]

OWC version 11, MS Office Pro 2003.

What does "re-register that version at the command prompt" mean? Sorry if
I'm dense but I'm not even sure what you mean by "command prompt." There
doesn't appear to be mention of one in the VBA documentation.

Do you mean rebooting in Safe Mode to a command prompt?
Do you mean Start -> Run...? Regedit?

And then what? Thanks in advance for your clarification.

what version are you working with? Try re-registering that version at the
command prompt.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

I have an OWC 11 ChartSpace on a UserForm. I would like to use the
ExportPicture method but receive Error 430 instead: "Class does not
support
Automation or does not support expected interface." I have tried adding
the
ChartSpace at run time and at design time. I have followed the example in
the
documentation verbatim. The method simply does not work.

Suggestions?

 

[Alvin Bruney - MVP ASP.NET]

a lot of OWC problems are caused because of missing registration keys. To
fix this, open a command window and navigate to the owc10.dll or owc11.dll
and type this at the command prompt regsvr32 owc10.dll. a dialog box will
show the registration succeeded and then you can retry the application to
see if it fixed.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

OWC version 11, MS Office Pro 2003.

What does "re-register that version at the command prompt" mean? Sorry if
I'm dense but I'm not even sure what you mean by "command prompt." There
doesn't appear to be mention of one in the VBA documentation.

Do you mean rebooting in Safe Mode to a command prompt?
Do you mean Start -> Run...? Regedit?

And then what? Thanks in advance for your clarification.

what version are you working with? Try re-registering that version at the
command prompt.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

I have an OWC 11 ChartSpace on a UserForm. I would like to use the
ExportPicture method but receive Error 430 instead: "Class does not
support
Automation or does not support expected interface." I have tried adding
the
ChartSpace at run time and at design time. I have followed the example
in
the
documentation verbatim. The method simply does not work.

Suggestions?

 

[Pat Finegan]

I keep getting an error message: "LoadLibrary ('owc11.dll') failed. The
specified model could not be found."

I verified the existence of both owc11.dll and regsvr32.exe via File Manager
and then tried the following combinations in both Start -> Run and Start ->
Programs -> Accessories -> Command Prompt:

1. regsvr32.exe owc11.dll
2. regsvr32 C:\Program Files\Common Files\Microsoft Shared\Web
Components\11\1033\owc11.dll
3. c:\windows\system32\regsvr32 owc11.dll
4. c:\windows\system32\regsvr32 C:\Program Files\Common Files\Microsoft
Shared\Web Components\11\1033\owc11.dll
5. c:\windows\system32\regsvr32 C:\Program Files\Common Files\Microsoft
Shared\Web Components\11\owc11.dll (exists in 2 directories)

See http://shareholdervalue.com/images/misc/owc_01.dll and
http://shareholdervalue.com/images/misc/owc_02.dll for image files of the
error message and how I generated it.

Please let me know what I'm doing wrong. Thanks in advance.

 

[Alvin Bruney - ASP.NET MVP]

Your URI links are bad.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Pat Finegan]

I'm so sorry. (Is there a preview feature on this board?)

http://shareholdervalue.com/images/misc/owc_01.jpg
http://shareholdervalue.com/images/misc/owc_02.jpg

Thank you for your patience.

Your URI links are bad.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I keep getting an error message: "LoadLibrary ('owc11.dll') failed. The
specified model could not be found."

I verified the existence of both owc11.dll and regsvr32.exe via File Manager
and then tried the following combinations in both Start -> Run and Start ->
Programs -> Accessories -> Command Prompt:

1. regsvr32.exe owc11.dll
2. regsvr32 C:\Program Files\Common Files\Microsoft Shared\Web
Components\11\1033\owc11.dll
3. c:\windows\system32\regsvr32 owc11.dll
4. c:\windows\system32\regsvr32 C:\Program Files\Common Files\Microsoft
Shared\Web Components\11\1033\owc11.dll
5. c:\windows\system32\regsvr32 C:\Program Files\Common Files\Microsoft
Shared\Web Components\11\owc11.dll (exists in 2 directories)

See http://shareholdervalue.com/images/misc/owc_01.dll and
http://shareholdervalue.com/images/misc/owc_02.dll for image files of the
error message and how I generated it.

Please let me know what I'm doing wrong. Thanks in advance.

 

[Pat Finegan]

OK, I successfully registered OWC11.DLL (forgot quotation marks around the
filename in the examples above), but still get Error 430 when I attempt use
the ExportPicture method on an OWC ChartSpace object:

UserForm1.ChartSpace1.ExportPicture "test.gif", "gif", 100, 100

 

[Andrew Smith]

OK, I successfully registered OWC11.DLL (forgot quotation marks around the
filename in the examples above), but still get Error 430 when I attempt use
the ExportPicture method on an OWC ChartSpace object:

UserForm1.ChartSpace1.ExportPicture "test.gif", "gif", 100, 100

 

[Andrew Smith]

I have a similar issue I am trying to export a pivot chart to an image for
inclusion in a
powerpoint report. The code I am using is:

Sub ExportPivotChart()

Dim frm As form
Dim chartSpaceObj As OWC11.ChartSpace

For Each frm In Forms
If frm.Name Like "gra*" Then
Set chartSpaceObj = frm.ChartSpace
chartSpaceObj.ExportPicture "c:\test.gif", "gif", 1024,
1024
End If
Next frm

End Sub



if I use OWC10 then I get an RTE 430: Automation Error when it comes to the
export picture method. If I use OWC11 I get a RTE 13: Type Mismatch when
setting the chartspace object to the chartspace of my form. Could anyone
suggest what I am doing wrong Please? This appears to do excatly whats
suggested in the MS help etc...

Thanks

Andrew

 

[Andrew Smith]

I have fixed my issue with OWC10 by rolling back the dll from version
10.0.6765.0 to 10.0.6619.0. This appears to have sorted my issue - at last.

Is there a newer version of the component available with a fix to this bug?