Problem Opening SharePoint Folder in WINDOWS Explorer

[JMH022]

I am having a problem opening a SharePoint folder (not a specific file in the folder) using VBA.

I have searched Mr. Excel extensively and have found MANY suggestions to try using...

FolderPath = "http://nexus/sites/.../MySharePointFolder"
Shell "explorer.exe " & FolderPath, vbNormalFocus

...but this is opening my SharePoint folder in Internet Explorer...not WINDOWS Explorer.

I want to view the contents of my SharePoint page in the same way as if I went into LIBRARY in SharePoint and clicked on the [Open in Explorer] button from the Ribbon.

Am I missing something that will force the folder to open in WINDOWS Explorer?

I appreciate the help!

 

[lmosscornerstone]

Hi Jim, did you ever figure this out? I'm having the same issue

 

[JMH022]

Hi Jim, did you ever figure this out? I'm having the same issue

Unfortunately not.

 

[DJ1andDT2]

Jim, Perhaps I can be of assistance if you haven't fixed the issue yet.

change the FolderPath to be a similar to the C:\ view as you want the server view/file explorer.

[COLOR=#333333]FolderPath = [B]"\\nexus\site\...\MySharePointFolder"[/B][/COLOR]

Please note if you have the right access you can get the exact link from the SharePoint site by clicking the Library tab then "Open with Explorer" from the Document Library on SharePoint.

hope this helps!

 

[maupetst]

you must remove "http:" from the file path... it should work in windows explorer.

 

[JEC]

Make sure you have synced your sharepoint folder to your explorer first