Code to export chart not working after converting to a2003 from a2

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