Excel 2003 operates differently on FILE SAVE AS?
 

I have a routine with the following text:

ActiveWorkbook.SaveAs Filename:="c:\BLP\WINTRV\US News Teams.sty",
FileFormat:=xlTextPrinter, CreateBackup:=False

However, when I retrieve the original file, US with Voices.xls, it has
been saved over in the text format and all the macros, worksheets,
etc., that should be associated with it is missing.

Why does SAVEAS not work as SAVEAS? why did it overwrite my file?
tia ...

Excel 2003 operates differently on FILE SAVE AS?
 

Your code didn't overwrite the original for me (also using xl2003).

I'd suspect that someone overwrote your original in error.

Larry wrote:

I have a routine with the following text:

ActiveWorkbook.SaveAs Filename:="c:\BLP\WINTRV\US News Teams.sty",
FileFormat:=xlTextPrinter, CreateBackup:=False

However, when I retrieve the original file, US with Voices.xls, it has
been saved over in the text format and all the macros, worksheets,
etc., that should be associated with it is missing.

Why does SAVEAS not work as SAVEAS? why did it overwrite my file?
tia ...

--

Dave Peterson