• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy folder from Sharepoint to Local Drive

R

ranjithr

New Member
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
 
You'll need to provide more detail.
Version of SharePoint? Local or hosted?
What access level do you have to the server housing SharePoint?

If it's local. Easiest way to do what's needed is to replace "https://sharepoint.company.com/" with UNC path to your server and work directly with server, rather than through SharePoint web service.
Ex: \\"host_ipaddress or DNS name"\path\sites\partsDatabse

Alternate method is to use SharePoint Rest API (check MS documentation).
 
Thanks for the reply Chihiro.
We are using the sharepoint part of Office 365 tool. It is not local. I have only view permisssion for the sharepoint. No admin access.
 
Then you would need your admin to turn on API access for you. Use either MS Graphs API which is unified API for MS Cloud space or SharePoint API.
 
Sure it can. You just have to leverage the API. Since there are securities set up for data/file transfer.

Alternately, if you are able to, you can just sync the SharePoint folder to local drive. Though that may need your IT/Office 365 admin involvement as well.
https://docs.microsoft.com/en-us/sharepoint/let-users-use-new-onedrive-sync-client
https://support.office.com/en-us/ar...503-80b2-6190f3354a88?ui=en-US&rs=en-US&ad=US

Edit: You may have some luck using below method. Though again, it will depend on your access level on your network.
https://bauensolutions.com/2017/01/...arepoint-online-library-like-a-network-drive/
 
You must log in or register to reply here.
Back
Top