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

Hamvis 11 Reputation points
2021-09-16T08:37:36.6+00:00

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?

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,668 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Elsie Lu_MSFT 9,761 Reputation points
    2021-09-17T07:28:31.837+00:00

    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.

    132919-67.jpg

    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.