VBA expressing a UNC path

[Pinaceous]

Good Day All,


My question is how do use a UNC path instead of (\\SharePointServer\Path\MorePath\DocumentLibrary\Folder) and express this through VBA code?

Here is something that I was reading on Get the content of a SharePoint folder with Excel VBA but I'm not sure.

Can anyone help?

Thanks,
pinaceous

 

[Micron]

That looks like a UNC path to me. If it wasn't, it would start with a drive letter (e.g. F:\ ) ?
What worked for me:
\\sharepoint\CompanyName\DivisionName\BusinessUnitName\DepartmentName\etc\etc

 

[Pinaceous]

I'm trying to figure out how to post my files.