FileDialog Mapped Drive VBA

[Parsnips]

My VBA code needs to interact with files from SharePoint, and I'm having some difficulty...the connection seems to periodically disconnect, making it impossible to use the dir function.

As a workaround, I was going to use the SharePoint as a mapped drive, but using the File Dialog returns the SharePoint URL instead of the mapped drive path. Is there a way to get it to return the mapped drive path?

Thank you,
Parsnips

 

[mole999]

can you not just replace

X:\something with

\\location\location\something

 

[Parsnips]

Unfortunately, while it works sometimes, that often results in an error 52- even when I am logged into SharePoint.