Don't let the system confuse you too much. I don't think there's a way to
force one or the other types of addressing. It is kind of determined by how
you got to the file to begin with. If you went through My Network Places to
open a file to begin with, then even the library.xls file would show the
network/Novell path. That is actually a safer, better way to do things when
you may distribute the Excel file to others unless you can guarantee that all
users will have network locations mapped in exactly the same way.

On the other hand, on any given machine, when you open the file, any path or
name that it hands you will work during that session with the file.

Does that help any?

"Nicholas Dreyer" wrote:

On my system at work, Novell server folder name:
\\LC30\VOL1\USERS\ResearchandDevelopment
maps to Windows full path name H:\ResearchandDevelopment

If I open excel workbook library.xls located in this folder from the
excel file/open menu, and look at VBA expression
Workbooks("application.xls).path I see the windows path name
H:\ResearchandDevelopment.

If library.xls is openend automatically through a VBA refernce to it
in another workbook that is opened, Workbooks("application.xls").path
contains the Novell path name \\LC30\VOL1\USERS\ResearchandDevelopment

Is there a way towhich naming convention is used? It is very
difficult to write code to manipulate files when two completely
different looking paths can refer to the same location.

Thanks for any tips.

Nick