how can I shorten up this line with my 'Dir' Names I am moving and renaming a file within the same older path can I eliminate the way I have it.... some times the location changes but it will always be in the same folder.
I have 2 directories
EDir = Sheet24.Range("av2").Value
EDir2 = ThisWorkbook.Path & "\TEMP\"
this line works if i describe the path using the one below but needs to be adjust to work with my "EDir & EDir2"
Name "C:\Users\MWD\Desktop\MDC_MD181010_OMAHA 11-2 2HM\DATABASE\OMAHA 11-2, 2HM\RawSurveys.xls" As _
"C:\Users\MWD\Desktop\MDC_MD181010_OMAHA 11-2 2HM\TEMP\MovedRawSurveys.xls"
I tried but it did not work
Name "EDir \ RawSurveys.xls" As "EDir2 \ MovedRawSurveys.xls"
Thanks
Bookmarks