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.
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