Copy Excel file on Sharepoint via VBA

[Sinem]

Hi,

at the moment my code copies an excel file from an windows explorer path (Source_path) and puts the file in a new path (Destination_path), opens it and does some formattings and saves it.

This procedure should be done on Sharepoint. I don't want to download the file. The source file is already on Sharepoint.

Have you any idead how to do this?

 

[steve the fish]

You will have to download the file if you want to use VBA. VBA isnt available to excel online.

 

[Sinem]

Hi thank you for your response. Have you any advice how to download files and upload them again on sharepoint via Excel VBA

 

[steve the fish]

I wouldnt know how to do that. Its probably possible so ask google. Im sure somebody has done it before.

 

[Sinem]

The trick is that you have to replace the path with Sharepoint's path in Windows Explorer. Then the copy method works.