I am trying to save files to the "Shared Documents" directory on a Sharepoint
site.

the code wkbTarget.SaveAs(URL of SharePoint Site) results in a 1004 error:
File Not Saved.


My URL is (redacted to maintain confidentiality)
"https://sharepoint.xxx.com/xxx/xxx/xx/xxx/Shared%20Documents/Excel_Filename.xlsx" .

It worked once, then I deleted the file from the site. Since then, it
hasn't worked.

Can someone point me in the right direction?

many thanks,
Harry