That's what I was referring to in my first response.
IF the shortcut used the absolute name
\\servername\pathname\filename.xls
then, it would be independent of the drive map.
and he could use activeworkbook.fullname or path.

Joe indicated that in HIS office, these drive maps are "fixed".
Where I am, with 1000 PC's, NOTHING is "fixed"!!!
but it sounds like Joe will be fine with the drive map.