+ Reply to Thread
Results 1 to 2 of 2

Excel 2008 : Hyperlink Wildcard as a filename

  1. #1
    Registered User
    Join Date
    06-23-2010
    Location
    Cape Town South Africa
    MS-Off Ver
    Excel 2010
    Posts
    1

    Hyperlink Wildcard as a filename

    I understand the folling hyperlink formula =HYPERLINK("T:\Information\37.pdf",B5).

    In the example above my filename = 37.pdf. Is there a way I can add a wildcard after the 37 for example T:\Information\37*.pdf and the hyperlink will then open the first file that starts with 37?

    Why am I asking the above:
    I've got a spreadsheet with numbers in the cells, these numbers corresponds to pdf files in a paticular place.
    But unfortunatly except for the numbers that is in the filename, the filename ends with a timestamp (date, hour, min, sec) hence i dont want to type in the whole filename.

    Hope this is clear enough.

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Hyperlink Wildcard as a filename

    I believe it has been established that wildcards will not work in a hyperlink formula.

+ 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