Hello,

I'm looking for a VBA to copy a specific excel file from one SharePoint to another SharePoint site.

For instance. One of my site is a Teams SharePoint and the another one is Online SharePoint.

In Online SharePoint, I have a excel file named as "Annual Packages".

Is there a way, on daily basis, the file that is stored to Online SharePoint, that file gets replaced to the Teams SharePoint.

Please advise.