Copy Excel files from local system to SharePoint

[arpan.karmakar]

I've got some files in my local system and I want to copy them to SharePoint. I have created a master file which contains the path where the files is currently saved and the destination path.

I need a VBA code to copy the files from the source and paste them into SharePoint.

 

[robert.miller]

Why do you need to write a script? You can simply just drag the file into SharePoint if the access permissions are set correctly. Or you can set up an external reference in the Library that links to an outside source.