We've resolved the problem :) , but still not sure why it happene
.

The original template worksheet that we were attempting to reopen a
the end of the macro was written with its UNC address (because we hav
users with varying drive letter mappings for this network directory).
When we changed it to the drive letter mapping, it worked perfectly.
So we programmed into the macro the ability to identify the particula
user's drive letter mapping and used that in the filename variable.
Works like a charm! ;)

Now our puzzle is, why did it work without issue using the UNC addres
last year (and apparently even on one person's pc on Monday), but bega
having the problem yesterday (Tuesday)?

Anybody care to venture a guess on that one?

By the way, thanks for your suggestions Dave

--
taylor
-----------------------------------------------------------------------
taylorm's Profile: http://www.excelforum.com/member.php...fo&userid=2889
View this thread: http://www.excelforum.com/showthread.php?threadid=52499