VBA Upload saved file to SharePoint

Hi everyone,

Racking my brains on why this keeps coming up as a Runtime error '76'? Path not found?

Please Login or Register  to view this content.

If i try and open the site individually from the VBA - it works... If it open the file individually from the VBA, it works...

I've been googling it for about 3 hours I've tried loads of different code, none of which work... Tried adding different References, nothing worked Tried /'s and \'s also...

**Also the file does exist in the location**

Any help on this matter would be great!

Thanks!

How is your SharePoint set up?

Is it hosted on local server? Or is it SharePoint Online?

If former, is it on single db backend which is housed in same server as SharePoint services?

The path should then be something like...
"https://companyname.sharepoint.com/sites/sitename/Shared Documents/filename.xlsb"

If you need to find exact path to the file/folder. First load some document manually to the site.
Then open the file in browser, and Edit Workbook -> Open in Excel (desktop app).
Once the file is open in local Excel, go to File -> Info then click on Copy path button.

Paste the result to text editor and remove "filename.xlsb?web=1" part. Remaining part is your path to SharePoint folder.
Note that you must be logged in to SharePoint/Office 365 account on your Excel instance to be able to use it.

Oh, one thing you can try. Instead of using FileCopy.

Try using Workbook.SaveAs to the SharePoint path.

FYI - I'd not recommend sending sensitive link, even in PM You never know if I can be trusted.