a2003-code doesn't work

S

sailcm

My company recently converted to access 2003 and now I have a bit of code
that doesn't work to export a pivot chart as a picture. I have converted the
database from the previous version to a2003 format.

The code is:
me.chartspace.exportpicture MyPath

I got the code from
http://office.microsoft.com/en-us/assistance/HA010345791033.aspx

This article says that I have to have reference to the OWC11.dll, which I do.
I have unregistered and re-registered both the OWC11.dll and the DAO360.dll
per the suggestion of Allen Browne's article "Solving Problems with Library
References.

The error I'm getting is
"run-time error '430'
Class does not support Automation or does not suppor expected interface"

This is the list of reference library's that are active:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office XP Web Components

I've got a bunch of charts that need to go into a powerpoint show for a big
meeting next week, so I'd appreciate any help...
Thanks.
 
S

sailcm

Yes. The error message is:
"run-time error '430'
Class does not support Automation or does not suppor expected interface"
 
M

Microsoft

U¿ytkownik "sailcm said:
My company recently converted to access 2003 and now I have a bit of code
that doesn't work to export a pivot chart as a picture. I have converted
the
database from the previous version to a2003 format.

The code is:
me.chartspace.exportpicture MyPath

I got the code from
http://office.microsoft.com/en-us/assistance/HA010345791033.aspx

This article says that I have to have reference to the OWC11.dll, which I
do.
I have unregistered and re-registered both the OWC11.dll and the
DAO360.dll
per the suggestion of Allen Browne's article "Solving Problems with
Library
References.

The error I'm getting is
"run-time error '430'
Class does not support Automation or does not suppor expected interface"

This is the list of reference library's that are active:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office XP Web Components

I've got a bunch of charts that need to go into a powerpoint show for a
big
meeting next week, so I'd appreciate any help...
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top