Run-time error 76

[Galceran]

A new macro runs to format a worksheet then SavesAs, at which point error 76 path not found appears.

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

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

 

[Trebor76]

Any ideas?

Record a macro saving the file to the desired location and then check the syntax.

 

[Galceran]

Thanks. I shall do this later today and post the result
Gilbert

 

[Galceran]

The syntax is correct. Same files on the PC Macro runs the same macro and saves without a problem.

 

[Trebor76]

Same files on the PC Macro runs the same macro and saves without a problem

Could be that the directory has been hard harded to save to "C:\Users\Arthur\My Documents\My Data Sources" which is only applicable to the user "Arthur" i.e. someone else is running the code when it fails as they don't have the "C:\Users\Arthur\My Documents\My Data Sources" path on their machine.