| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get path - save new file - same sub-directory as existing file
Is it possible to amend this code to get the path so as to save the new file
in the same sub-directory as the existing file? Worksheets(1).Select ActiveWorkbook.SaveAs Filename:=Format(Range("H22").Value, "d MMMM yyyy") & " NEW.xls" _ -- DL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save file to same directory folder | Excel Discussion (Misc queries) | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
| How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
Threaded Mode
