export chart method error - excel2003
Art,
If you are not on an English system, as Peter T pointed out recently, "GIF"
may fail. A workaround is
Dim MyFileName As String
MyFileName = "C:\GifTest.gif" 'Make sure the filename has the extension
ActiveChart.Export Filename:=MyFileName , filtername:=""
Also, the Interactive argument seems to have no effect.
This works in XL2000/2002, not sure about 2003.
NickHK
"Art Parra" wrote in message
...
The following method fails on 2003 but runs ok on 2000.
activechart.export filename:=myfilename, filtername:="GIF"
I get a runtime 1004 error: method export of object chart failed
thanks,
|