| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet displays differently in Excel 2003 SP2 & SP3 | Excel Discussion (Misc queries) | |||
| excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
| How do I save aN Excel 2003 file with a preview? | Excel Discussion (Misc queries) | |||
| after i save the file my hyperlink does not work in excel 2003 | Excel Worksheet Functions | |||
| Pivot table displays data differently, Excel 2003 | Excel Worksheet Functions | |||
![Larry[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
