Chart Export Issues

S

sather.brian

This is a problem I've dealt with for some time. I try to use this
code to export a chart as a GIF file and from the postings I've read,
there have been no problems. However, everytime I try to run this it
gives me a Run Time error '1004' and I cannot figure out why. The
exact code as is below.

Fname = ThisWorkbook.Path & Application.PathSeparator & "Chart.gif"
Worksheets("Charts").ChartObjects(1).chart.Export Filename:=Fname,
FilterName:="GIF"

The two things I notice are that VB automatically puts a lowercase C on
chart and a lowercase N on Filename - I don't know what this indicates.

The Export function is in my object browser so it must be loaded in -
but it does not work.

What am I missing?
 
A

Andy Pope

Hi,

Are you sure you have the appropriate graphic filters loaded?

You can check using Control panel > Add/Remove Programs and changing the
Office settings. for xl2003 at least they are in the Office Shared
Features > Converters and Filters > Graphic Filters.

Cheers
Andy
 

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

Image on userform from picture in a worksheet 2
paste 2 charts on the same image on a userform 2
Programatically Export Excel Chart to Graphic in SharePoint 5
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; 5
Export Chart as TIFF or JPG 8
Chart Picture Size in UserForm/Picture Control. 8
chart to email 3
Exporting Chart sheets as gifs 2

Top