| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving filename same as import filename
I tried this code but I get an error that says Method 'SaveAs' of object '_Workbook' failed. I can't figure out what the problem is other than maybe it is naming the excel workbook the same as the text file it is importing. For example it is naming it test.txt.xls. Could this be a problem? fileToOpen is the name of the text file that I am importing. Thanks. Mat
ActiveWorkbook.SaveAs Filename:="H:\" & fileToOpen & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving file using value in cell as the filename | Excel Worksheet Functions | |||
| Saving XLS workbook with set filename | Excel Discussion (Misc queries) | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| Filename import | Excel Discussion (Misc queries) | |||
| Saving Cell value as filename | Excel Programming | |||
Threaded Mode
