VBA issues upon SharePoint

[Pinaceous]

Good Day,

Using VBA upon a SharePoint, I've noticed the path is https which are not a structured location for a file transfer and know that this is not an isolated issue.

How do use a VBA code to use a UNC path instead of (\\SharePointServer\Path\MorePath\DocumentLibrary\Folder)?

The VBA code will have to first check for https and then covert the path to UNC manually. It will also have to check, which settings are used upon my SharePoint server for this to happen.

I know there are quite a few articles on this subject but none officially from Microsoft.

Please let me know your thoughts, if in code or articles.

Thank you!
pinaceous