First, it shouldn't matter if the user is opening the workbook using the UNC
path or a mapped drive--unless you have two different versions of the file.

There are API functions that will convert mapped drives to its UNC path.

But there aren't any that will convert a UNC path to a mapped drive if the user
doesn't have that UNC path already mapped.

I think you're going down the wrong road thinking that the problem is with the
wrong path.

I'd still bet that the users with problems opening the wrong workbook.



Shazbot79 wrote:

thanks to all your help I'm a little further forward.

I added msgbox activeworkbook.fullname to run when the workbook opens.
For those people not having the issue the workbook is displayed along
with its DOS filepath, for those having the problem the workbook is
displayed in the msgbox along with the UNC filepath. Is there any code
I can add that will force Excel to use the DOS filepath in the
properties of the workbook?

Thanks again for your efforts so far.

--

Dave Peterson