I am currently attemping to save a file (save or overwrite if there is an existing file in this directory) to a specified path via this code:
fname = "L:\GlobalscSh\Data Standards Documentation\GSC QA\" & ThisWorkbook.Name
Application.DisplayAlerts = False
ThisWorkbook.SaveAs fname
ThisWorkbook.Close
Application.DisplayAlerts = True
Each time I execute the code, it returns:
Run-time Error 1004
Application or Object Defined error.
I am confused why this code is not working. I would appreciate any and all advice.
Thanx
Kevin Vogt
fname = "L:\GlobalscSh\Data Standards Documentation\GSC QA\" & ThisWorkbook.Name
Application.DisplayAlerts = False
ThisWorkbook.SaveAs fname
ThisWorkbook.Close
Application.DisplayAlerts = True
Each time I execute the code, it returns:
Run-time Error 1004
Application or Object Defined error.
I am confused why this code is not working. I would appreciate any and all advice.
Thanx
Kevin Vogt