Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chart to GIF file
I use win98 and xl2002 and your code resulted in only one file for me.
Dick Scratcher wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chart to GIF file
Have since tested on a W2000 network (Excel XP again). Same code produces the
one expected file. This appears to be a Netware problem - any comments? Dick "Dave Peterson" wrote: I use win98 and xl2002 and your code resulted in only one file for me. Dick Scratcher wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chart to GIF file
I've never used Netware.
good luck, Dick Scratcher wrote: Have since tested on a W2000 network (Excel XP again). Same code produces the one expected file. This appears to be a Netware problem - any comments? Dick "Dave Peterson" wrote: I use win98 and xl2002 and your code resulted in only one file for me. Dick Scratcher wrote: 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 -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chart to GIF file
Hi Dick,
If it works properly if you save it to your hard drive as opposed to the network, I would expect you are having a problem with network administration or with an antivirus program. Excel likes to rename a file, create a file, rename it, and then delete the original file. I expect something is interfering with that process. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Peterson" wrote in message ... I've never used Netware. good luck, Dick Scratcher wrote: Have since tested on a W2000 network (Excel XP again). Same code produces the one expected file. This appears to be a Netware problem - any comments? Dick "Dave Peterson" wrote: I use win98 and xl2002 and your code resulted in only one file for me. Dick Scratcher wrote: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chart to GIF file
Thank you for the feedback.
This is part of an established process that we are migrating to XP. The example was the result of our analysis of the problem. The nature of the business is such that local harddrives are not writable by users (security issues etc). We have got around it by accepting that two files are produced and we look for the one that doesn't have zero bytes. I know it works okay by saving it to anywhere other than to a Netware server. I was hoping that someone might have met this problem and resolved it, for example, a Microsoft or Netware employee. Thank you for your contributions Dicky "David McRitchie" wrote: Hi Dick, If it works properly if you save it to your hard drive as opposed to the network, I would expect you are having a problem with network administration or with an antivirus program. Excel likes to rename a file, create a file, rename it, and then delete the original file. I expect something is interfering with that process. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Peterson" wrote in message ... I've never used Netware. good luck, Dick Scratcher wrote: Have since tested on a W2000 network (Excel XP again). Same code produces the one expected file. This appears to be a Netware problem - any comments? Dick "Dave Peterson" wrote: I use win98 and xl2002 and your code resulted in only one file for me. Dick Scratcher wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting chart issue | Charts and Charting in Excel | |||
exporting chart | Excel Discussion (Misc queries) | |||
Exporting CSV file to unicode .txt file - " around strings | Excel Discussion (Misc queries) | |||
Exporting the chart automatically | Charts and Charting in Excel | |||
Trouble exporting chart to htm file - need help | Excel Programming |