Hi Excel Masters,
I have a requirement that calls for downloading folders from SharePoint to local drive. The folder consists of different file formats and subfolders too. I have a list of names of files in an excel file. The work that is been done is to take the name of the folder from excel, search in SharePoint and download the folder.
Source path : https://sharepoint.company.com/sites/partsDatabse
Destination Parth : C:\data
folder list : Folder1, Folder2 etc.
To automate that I have looked into various macros, but none of them seems to be working since the source path is Sharepoint. I cannot map the SharePoint as network drive too since the list of folders is more than 70000.
Request your expertise in solving the problem statement. Thanks in advance
I have a requirement that calls for downloading folders from SharePoint to local drive. The folder consists of different file formats and subfolders too. I have a list of names of files in an excel file. The work that is been done is to take the name of the folder from excel, search in SharePoint and download the folder.
Source path : https://sharepoint.company.com/sites/partsDatabse
Destination Parth : C:\data
folder list : Folder1, Folder2 etc.
To automate that I have looked into various macros, but none of them seems to be working since the source path is Sharepoint. I cannot map the SharePoint as network drive too since the list of folders is more than 70000.
Request your expertise in solving the problem statement. Thanks in advance
