Automate process to download and upload files from sharepoint

[Shraddha]

I want to download four file from sharepoint, consolidate and paste them in excel. Run calculations and refresh pivots. Then delete unwanted tabs and upload back to sharepoint

 

[Thangavel]

To download file from Sharepoint,
Please have a look here in the thread: https://chandoo.org/forum/threads/v...from-sharepoint-to-local-network-drive.25320/

Code:http://ckannan.blogspot.com/2012/09/vba-download-files-from-sharepoint.html

 

[Shraddha]

I am new to the coding world.. Can you guide for the same?