Path with server/share in footer rather than Drive letter

[SandsB]

If I use &[Path]&[File] I get the drive letter. I can manually spell it all out to get the server/drive in the footer BUT.... I'm not just looking for a shortcut. I'd like something that'll work if a file moves from one server to another without me remembering to do a manual update. Can it be done?

 

[Micron]

I think you will need a function such as this one (and a reference to filescripting library)

Convert Shared folder path to UNC path

I'm trying to convert current shared folder path to unc path by manipulating current path with computer name. However result in compile error: expected array on the line"elem = UBound(CurrentPathA)...

stackoverflow.com

It doesn't work for me because I don't have a shared drive to test it on.