+ Reply to Thread
Results 1 to 2 of 2

Hyperlink Locates file regardless of it's location

  1. #1
    AC
    Guest

    Hyperlink Locates file regardless of it's location

    Hi,

    I have a 100's of hyperlinks that take a part number from a cell and
    then point to and open a corresponding pdf drawing located in
    z:\\server-h\vol1\data\xx.pdf
    However some of the pdf files are located in '...vol2\data\xx'
    Can the hyperlink not have a formula or some msdos command in it so
    that it can search for a particular filename by itself on the whole
    hard drive. This way if the pdf files get moved around there will be no
    problem with the hyperlinks? I'm using Excel XP 2002.

    Thanks,

    Avais


  2. #2
    Harlan Grove
    Guest

    Re: Hyperlink Locates file regardless of it's location

    AC wrote...
    >I have a 100's of hyperlinks that take a part number from a cell and
    >then point to and open a corresponding pdf drawing located in
    >z:\\server-h\vol1\data\xx.pdf
    >However some of the pdf files are located in '...vol2\data\xx'
    >Can the hyperlink not have a formula or some msdos command in it so
    >that it can search for a particular filename by itself on the whole
    >hard drive. This way if the pdf files get moved around there will be no
    >problem with the hyperlinks? I'm using Excel XP 2002.


    No.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1