fso.CopyFile Errors 70/76

[nikki333]

Hi folks

I'm trying to save a copy of the active workbook via fso.CopyFile (Source as String, Destination as String) method.

This works as expected with local files. However, the source file needs to be on a network share. So there seems to be an issue with the source path.

I've tried the following so far:

http://apps.xyz.net/ch/qms/Work/File Name.xlsm 'Error 76, Address retrieved from ThisWorkbook.FullName
http://apps.xyz.net/ch/qms/Work/File%20Name.xlsm 'Error 76
\\apps.xyz.net\ch\qms\Work\File%20Name.xlsm 'Error 70 , UNC converted
\\apps.xyz.net\ch\qms\Work\File Name.xlsm 'Error 70

Any ideas?

[nikki333]

Solved it by using



ThisWorkbook.SaveCopyAs (Destination)


So I don't need to worry about the network path