Chart.Export failure on certain machines

[Paul Martin]

Hi all

I am loading a chart as a GIF onto a UserForm by first exporting the
chart using Chart.Export method. This method works on my machine (and
others) but is failing on others.

While debugging, I was able to select the relevant ChartObject, but not
the Chart property of the ChartObject. I can't find any reason why
this fails on some machines and not others. I can't understand why VBA
can find the ChartObject, but not the Chart.

Any suggestions appreciated.

Paul Martin
Melbourne, Australia

 

[Paul Martin]

Addendum - the error message is:

Run-time error '1004': Method 'Export' of object '_Chart' failed

 

[Paul Martin]

Please ignore this posting. I have since ascertained that the error
was caused by another add-in which was preventing the saving of files
(including Exports).