LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Exporting chart to GIF file

testing the export of a chart to a GIF file using this code:

Sub SaveChartAsGIF()
Dim FName
FName = ThisWorkbook.Path & "\" & ActiveChart.Name & ".gif"
ActiveChart.Export Filename:=FName, FilterName:="GIF"
End Sub

In Excel 97 it exported one file to:
GifExport Costs.Gif

BUT in XP it exports two files:
GifExport Costs.Gif as a zero length file and
GIFEXP~1.GIF that holds the data

Using Excel XP (with updates)
OS: XP Pro
Network: Netware

and

Using Excel 97(with updates)
OS: NT4
Network: Netware

Why?

Dick
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting chart issue JohnInStockie Charts and Charting in Excel 1 March 12th 07 12:51 PM
exporting chart paunie Excel Discussion (Misc queries) 0 June 2nd 06 04:37 PM
Exporting CSV file to unicode .txt file - " around strings Paul Excel Discussion (Misc queries) 1 June 14th 05 12:27 AM
Exporting the chart automatically Robert Hargreaves Charts and Charting in Excel 0 May 27th 05 05:28 PM
Trouble exporting chart to htm file - need help Jacson Excel Programming 3 January 10th 04 07:22 AM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"