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.

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

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