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