EXCEL-VBA: Proper formatting of the SharePoint URL/network file copy destination

The code supplied works properly, if my destination is a local PC file.  However, I have tried various suggestions and a common error code is 76, meaning there is something wrong with the path, or pe...