Excel 2003 operates differently on FILE SAVE AS?

L

Larry

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 ...
 
D

Dave Peterson

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA SaveAs function generates blank CSV file 4
Hiding an Excel file using VBA 1
Create Tab delimited file with no quotes in Currency fields. 0
45 seconds to save a file, why so long? 1
save worksheet with chinese characters as text 0
Recording a 'Save As...' 4
Module protection & Shell issues 1
How do I convert a macro that was created in 2003 Excel to 2007 8

Top