View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default export method not working properly

Are you using this? You can also try changing gif to jpg and try that.

Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub

--
Don Guillett
SalesAid Software

"Malone" wrote in message
...
I am having difficulty exporting charts to .gif files using the export
method. The charts look great in Excel, but the resulting .gif files are
often missing lines or axes or have other strange problems. Has anyone
experienced this and know how to improve things? I am using Excel 2002.

Malone