VBA check for Sharepoint folder exists on one machine, doesn't exist on another (both have access to site)

[sous2817]

Hello everyone,

I'm completely spinning my wheels on this. I've put together some VBA that does everything I need when I run it from my work laptop. When I move the file to my workstation and log in, the code falls over saying the SharePoint path is invalid. Since it's my log in for both machines, the corporate permissions are the same and I can manually access the site from both machines (and confirm that the folder is there).

The simplified code is this:

Sub test()
    Dim SharePointSite As String
    Dim fso As Scripting.FileSystemObject
    Dim b As Boolean
        
    Set fso = New Scripting.FileSystemObject
    SharePointSite = "\\{SHAREPOINT SITE HERE}"

    b = fso.FolderExists(SharePointSite)
    Debug.Print b
End Sub

This code returns true when I run it from my laptop and false when I run it from my workstation. If I put the sharepoint site in my browser, it takes me there fine on both machines.

Any ideas? Is there some permission somewhere that needs to be set?

 

[sous2817]

*bump for the weekend crew*

 

[sous2817]

OK, last bump for the Monday morning crew, then back to the drawing board...

 

[Austrada]

I am having the exact same issue.

Dim fso As Scripting.FileSystemObject
Dim LinusDir As Folder

Set fso = New Scripting.FileSystemObject
Set LinusDir = fso.GetFolder("\\{SharepointSite}\")

When I open the sharepoint folders in windows explorer first the code works perfectly, however if I try to run the code without opening the sharepoint first I get 'Run-time error 76 - Path No Found'.

This is fine for me but I need to send this out to other and do not want them to have to do this everytime.

Any help would be greatly appreciated.