+ Reply to Thread
Results 1 to 2 of 2

Hyperlink to a changing file name

  1. #1
    Registered User
    Join Date
    01-18-2011
    Location
    adelaide australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Hyperlink to a changing file name

    I have a list of pdf files in a folder;

    3_01877_400_015_REV_B5
    3_01877_400_016_REV_B4
    3_01877_400_017_REV_B2
    3_01877_400_018_REV_B1
    3_01877_400_019_REV_B2

    I have a excel file setup to act as a directory for all these files. I use hyperlinks to bring the user from the excel file to the pdf files in question.

    the problem is that the revision number B2, B4 etc. changes frequently. this then means that the hyperlink has to be changed.

    is there any way that the hyperlink can be constructed to just reference the beginning of the file name, for instance;

    "3_01877_400_016"

    excluding the revision number at the end? as long as there is only one "3_01877_400_016" in that folder, the hyperlink should then always open the file.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Hyperlink to a changing file name

    Welcome to the forum.

    Excel can't figure that out -- it would require VBA.
    Entia non sunt multiplicanda sine necessitate

+ 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