Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file
I have the following statements:
DataFileName = Application.GetOpenFilename(fileFilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") ....code 'Saves The File (As Sheetx) And Leaves It Open ActiveWorkbook.SaveAs 'Saves File As DataFileName But With The Extension Of the File Opened TXT Format And Not In Excel Format ActiveWorkbook.SaveAs (DataFileName) 'Receive Syntax Error ActiveWorkbook.SaveAs (DataFileName, FileFormat:="Excel (*.xls), *.xls") What am I missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
saving an excel file as an ASCII text file without delimiters | Excel Programming |