Hello all,

I run some VBA code spawning it from vbscript. Several workbooks are opened,
one of which has several sheets and one of these sheets has a chart in it.
The sheet name with the chart is named SPC.
In the VBA code contained in ThisWorkbook I have the following code:

Dim oSPCchart

Set oSPCchart = Workbooks("SPCbook").Sheets("SPC").ChartObjects(1)
oSPCchart.Chart.Export "d:\Verification\test.gif", "GIF"


The error is:
Run-time error 1004
Application-defined or object-define error

I have tried other code variants but always get some type of 1004 error.
Does anyone have any tips?

Thanks in advance, Milos.