I have a workbook that has a command button to make a backup save. My employer wants it on our Teams and saved on SharePoint. I cannot figure out how to alter the code to work. Here is what the current code is that saves to the specified location:

I am trying to copy files from one SharePoint folder to another.
From what I’ve read it appears that I probably need to map the SharePoint folders to network drive, but I just can’t work out how to do it.