View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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,