VBA Dir on SharePoint -why working only with Internet Explorer?

Question

I wanted to map some folders on SharePoint and create new subfolders via VBA. The SharePointURLtoUNC function found here: https://stackoverflow.com/questions/1344910/get-the-content-of-a-sharepoint-folder-with-excel-vba was really useful but there was another prerequisite for making all kinds of Dir commands work: I had to log in under Internet Explorer into SharePoint. It didn't work when I was only logged in under Chrome or Microsoft Edge. Could you please explain why is it so and how to avoid Internet Explorer login?

Answer 1

Hi @ZsVhun-6095 , welcome to Q&A forum!

What version of SharePoint are you using? We are currently providing help on SharePoint on the Q&A forum, so from the perspective of SharePoint, it may be due to the use of the MAP function, the browser requirement is IE10 and above.

Reference:
Map a network drive to a SharePoint library

=================================

You could also repost a thread with "Office-VBA-dev" tag, then you will get professional advice from the VBA team.

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.