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
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