 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2007export 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, 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 > The following method fails on 2003 but runs ok on 2000. > [quoted text clipped - 3 lines] > > thanks, 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 _______ > Art, > If you are not on an English system, as Peter T pointed out recently, [quoted text clipped - 18 lines] >> >> thanks, 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 > Or just leave off Filter, which is optional and defaults to GIF. > [quoted text clipped - 27 lines] > >> > >> thanks, 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 _______ > Just to add, the filter appears to default to that of the extension, eg > .gif, .jpg, ,jpeg, .tiff. [quoted text clipped - 36 lines] >> >> >> >> thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.