export method not working properly

M

Malone

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
 
D

Don Guillett

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
(e-mail address removed)
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
 
M

Malone

Yes, that is exactly what I am using. And I don't want to use jpg as the image isn't as good as gif for the sort of charts I am using.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Chart as TIFF or JPG 8
Issue with ExportAsFixedFormat PDF (and solution) 2
export method filter specific options 0
Chart Export Issues 2
AutoFit not working properly 8
Export autoshape as picture using VBA? (object doesn't support met 1
Export Report to Excel not working? 0
Application.FileDialog .Filters.Add method not working as expected 5

Top