T
tegger
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" _
in the same sub-directory as the existing file?
Worksheets(1).Select
ActiveWorkbook.SaveAs Filename:=Format(Range("H22").Value, "d MMMM yyyy") &
" NEW.xls" _