Chart Export Issues

  • Thread starter Thread starter sather.brian
  • Start date Start date
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?
 
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
 
Back
Top