All users should have the same drive
mapped. This workbook will reside on the network, on a specific drive
for our department (we have about a dozen drives specific to our
department), so that should be the same for everyone, correct? So in
that case, is the absolute pathname still the best? Or do you just
recommend doing it that way no matter what? We tried using the
servername in a Word template for something else, and could not get
it to work. So, if the servername is something like ismd002, the
drive letter is P, and the drive name is DataKinetics, how would you
specify the path? And then what would be the best way to test for
this in VBA?