Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Dynamically displaying share name

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    I was trying to find a way to dynamically display the complete network share name address of where my spreadsheet is storeed (i.e. \myservermysharemylibmyfile.xls).

    I've used =CELL("filename",C2) to dynamically display the address of a file BUT!!... if the location is a Network location only the drive I've mapped is displayed in the cell.

    HOW CAN I GET THE ENTIRE NETWORK PATH NAME TO DISPLAY?

    Thanks!
    Ken

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This does not work?

    =SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",
    CELL("filename",A1))),"[",""),"]","")
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No... that displays the same info. It will display the drive i've mapped to (ex: F:SharedFilesmyfile.xls

    I want it to display:
    \myservermyshareSharedFilesmyfile.xls

    "F:" is mapped to \myservermyshare

    Thanks!.....

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you access the file via the server route and not the mapped route, it will show the full path. Setting the shortcut to the server route instead of the mapped route and it should solve your problem.

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    see if this is returns anything different to =cell("filename",a1) :

    =INFO("directory")

    (I suspect it won't, but I'm at home, so can't test with different drive mappings etc)



  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris,
    that did not work.

    =INFO("directory") displayed my temporary directory Excel puts the file into while i open it.

    thanks for the thought though.....

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    EdE,

    you are correct..... but, it would be nice to display entire Network path name if someone has it mapped. This way if it is printed and distributed the complete path will be displayed on the printout.

    Thx!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •