FilterName:="GIF"

[alldreams]

FilterName:="GIF" won't work on my computer with excel
2002. It works on other computers with excel 2002 and
2000

Do you know how I can get FilterName for GIF installed in
my computer?

My macro is:

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

 

[Ken Macksey]

Hi

Don't know for sure, but you could try

FilterName:=".GIF"

that is dot gif


or

Filename:="c:\temp.gif", FilterName:="*.GIF"


and see if one of those works.

HTH

Ken

 

[Tom Ogilvy]

install the filters manually. To do this, follow these steps:
1.. Run Office XP Setup.
2.. Click Add or Remove Features, and then click Next.
3.. Click the plus sign next to Office Shared Features, and then click the
plus sign next to Converters and Filters.
4.. Click Graphics Filters, and then click Run from My Computer on the
shortcut menu.
5.. Click Update.