question

ZsVhun-6095 avatar image
0 Votes"
ZsVhun-6095 asked ElsieLu-MSFT commented

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

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?

office-vba-devsharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT commented

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.


67.jpg (46.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ZsVhun-6095 ,is there any update? I am willing to hear from you.

0 Votes 0 ·

Hi ElsieLue-MSFT,

Thanks for the answer.
I'm still testing the solution of synchronization mentioned in the link you provided (https://support.microsoft.com/en-us/office/map-a-network-drive-to-a-sharepoint-library-751148de-f579-42f9-bc8c-fcd80ccf0f53).
I'm looking for a solution that is completely independent from Internet Explorer and VBA still can check whether a folder exists on SharePoint.

0 Votes 0 ·

Hi @ZsVhun-6095 ,

Thanks for the reply. This case is more related to VBA. So I would suggest you to repost with a separate "Office-VBA-dev" tag, and then you will get professional advice from the VBA team. Thank you for your support and understanding. :)

0 Votes 0 ·