Take a look at this MapDrive() UDF: MapDrive() - Maps a UNC name to a specific driveletter .

It does support macros in the share name or label and still adheres to the NoVarsInStrings=ON mantra, which, BTW, does not affect macros anyway.
_________________________
There are two types of vessels, submarines and targets.