View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicholas Dreyer Nicholas Dreyer is offline
external usenet poster
 
Posts: 26
Default Novell server full path names of VBA references

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