| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |||
| editing an excel 97 file within excel 2003 and saving back as exce | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
| saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
