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

[Oliver]

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

 

[Jon Peltier]

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

 

[Oliver]

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