troubleshooting

[alldreams]

Sub test()
Sheets("CHARTS").Select
ActiveSheet.ChartObjects(1).Chart.Export
Filename:="c:\temp.gif", FilterName:="GIF"

End Sub

It worked from a different computer. From this computer,
I am getting the following error "Application Defined or
Object defined error".

Any suggestions?

 

[alldreams]

this macro works on excel 2000, not in excel 2002.

Any suggestions?

 

[Steve Garman]

Works OK here on 2002

All I did was rename a sheet to "Charts" add some simple data to it and
create a chart with the chart wizard then run this macro

Sub test()
Sheets("CHARTS").Select
ActiveSheet.ChartObjects(1).Chart.Export Filename:="c:\temp.gif",
FilterName:="GIF"
End Sub

 

[Steve Garman]

My guess is the GIF filter isn't installed on the target machine

 

[alldreams]

Hi Steve,

Do you know where I can download this missing GIF filter?

 

[Steve Garman]

It'll be on the CD. Use "Add/remove programs"

If you need more info, in XL 2002 help, type "gif filter" into the
Answer wizard

One of the options you get is "Install or remove individual components
in Microsoft Office"