LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Names of workbooks - want relative, with no Full Path Gdareos[_2_] New Users to Excel 1 April 21st 08 12:08 AM
Indirect does not recognize full server path? Matt Excel Worksheet Functions 3 January 6th 06 09:18 PM
problem updating link from Novell server to windows server #REF er Ellen Excel Discussion (Misc queries) 0 May 10th 05 09:18 PM
disk full problem on a server Corky Excel Discussion (Misc queries) 3 April 6th 05 09:35 PM
Recurring Problems with Links with Full Path Names JMcBeth Excel Discussion (Misc queries) 1 February 4th 05 10:11 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"