export chart method error - excel2003
 

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,

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,

export chart method error - excel2003
 

Or just leave off Filter, which is optional and defaults to GIF.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"NickHK" wrote in message
...
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,

export chart method error - excel2003
 

Just to add, the filter appears to default to that of the extension, eg
..gif, .jpg, ,jpeg, .tiff.

Though for some reason I can't seem to save as .bmp

Regards,
Peter T

"Jon Peltier" wrote in message
...
Or just leave off Filter, which is optional and defaults to GIF.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"NickHK" wrote in message
...
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,

export chart method error - excel2003
 

Peter -

You're right. I must have made up that "GIF" as default filter thing.
Apparently the filter name is only needed if the extension is not
recognized.

I couldn't save BMP or TIFF, but when I installed 2007 along with 2003 on
another machine, neither Excel could export a chart. Removing 07, deleting
all the image filters, and reinstalling 03 fixed it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Peter T" <peter_t@discussions wrote in message
...
Just to add, the filter appears to default to that of the extension, eg
.gif, .jpg, ,jpeg, .tiff.

Though for some reason I can't seem to save as .bmp

Regards,
Peter T

"Jon Peltier" wrote in message
...
Or just leave off Filter, which is optional and defaults to GIF.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"NickHK" wrote in message
...
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,