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

  • Thread starter Thread starter Oliver
  • Start date Start date
O

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
 
I don't know what might result in this error. This line:
The macro works on a different computer.
Click to expand...

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
 
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
 
Back
Top