| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get path - save new file - same sub-directory as existing file
Worksheets(?).Path
Alan "tegger" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get path - save new file - same sub-directory as existing file
Try something like
ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.Path & _ "\" & Format(Range("H22").Value,"d MMMM yyyy) & " New.xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "tegger" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
