I don't have a guess. In fact, I'm not sure why that would work.

Maybe the template file and one of the predefined file names were the same???

taylorm wrote:

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

The original template worksheet that we were attempting to reopen at
the end of the macro was written with its UNC address (because we have
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 particular
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 address
last year (and apparently even on one person's pc on Monday), but began
having the problem yesterday (Tuesday)?

Anybody care to venture a guess on that one?

By the way, thanks for your suggestions Dave.

--
taylorm
------------------------------------------------------------------------
taylorm's Profile: http://www.excelforum.com/member.php...o&userid=28892
View this thread: http://www.excelforum.com/showthread...hreadid=524999

--

Dave Peterson