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