Charts.add or ActiveSheet.ChartObjects.Add doesn't work
 

Hello All,
I am working with Excel 2007 and I would like to create a chart via a
macro.
If I use:
Charts.add

Then I can see how Excel creates a tab with the new chart and
immediately deletes it again.

When I create the chart with

with ActiveSheet.ChartObjects.Add (Left:=100, Width:=375, Top:=75,
Height:=225)
end with
I get the following error message
Run-time error '-2147467259(80004005)':
Automation error
Unspecified error

The macro works on a different computer.

Does anybody have an idea what could cause this problem?

Thanks,
Oliver

Charts.add or ActiveSheet.ChartObjects.Add doesn't work
 

I don't know what might result in this error. This line:

The macro works on a different computer.

sheds some light. It may mean that some gremlin has crept into the
misbehaving computer, or perhaps not all updates and service packs have
been applied.

First step: apply updates and service packs. Second step if needed: run
diagnostics (Office button Excel Options Resources Run Microsoft
Office Diagnostics). Third step if needed: reinstall Office.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 9/28/2010 2:40 PM, Oliver wrote:
Hello All,
I am working with Excel 2007 and I would like to create a chart via a
macro.
If I use:
Charts.add

Then I can see how Excel creates a tab with the new chart and
immediately deletes it again.

When I create the chart with

with ActiveSheet.ChartObjects.Add (Left:=100, Width:=375, Top:=75,
Height:=225)
end with
I get the following error message
Run-time error '-2147467259(80004005)':
Automation error
Unspecified error

The macro works on a different computer.

Does anybody have an idea what could cause this problem?

Thanks,
Oliver

Charts.add or ActiveSheet.ChartObjects.Add doesn't work
 

Hi Jon,
I tried step one and two, I am now at step three :-)

I was hoping that there might be another solution.

Thanks again,
Oliver