A new macro runs to format a worksheet then SavesAs, at which point error 76 path not found appears.
The path is correct. I now find that another macro which saves a different filename in the same location is returning error 1004. This macro previously ran and saved correctly.
Any ideas?
Thanks
Code:
ChDir "C:\Users\Arthur\My Documents\My Data Sources"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Arthur\My Documents\My Data Sources\tn11_merge.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Any ideas?
Thanks