CODEWITHSUNDEEP
vbaexcelsharepoint
jamheadart
jamheadart

Reputation: 5303

Error 76 - path not found, using FileSystemObject.GetFolder() with SharePoint address

What could be going on here?

I'm using:

Dim FOL As folder
Dim fs As New FileSystemObject

Set FOL = fs.GetFolder("//mycompany.sharepoint.com/etc/etc/")

And on my laptop it's working perfectly. Last week, it worked on my colleague's laptop perfectly. This week, it works on mine but it doesn't work on my colleague's! It gives a run-time 76 : 'Path not found' error.

We've both tried pasting the link directly in to an IE browser and it connects fine. So what could have changed between last week and this week to make it stop working on my colleagues' yet still work OK on mine?

One additional piece of info: On my browser in SharePoint I have the option to "Open with Windows Explorer" but my colleague doesn't.

EDIT: I believe my question is different to the similar here because this WAS working and now it wasn't. I'm asking what could have changed and is it linked to the lack of Action "Open with Windows Explorer".

Upvotes: 0

Views: 4413

Answers (1)

cbasah
cbasah

Reputation: 538

You could map the SharePoint folder to a drive letter.

This solution is discussed here: Get the content of a sharepoint folder with Excel VBA

Upvotes: 1

Related Questions