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