| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a hyperlink to open a file with part of the name
I am trying to create a Hyperlink to open a file from an Excel spreadsheet.
Only a part of the file name (a few characters) is in the spreadsheet. I tried using * as wild card character to represent other parts of the name. ex: =HYPERLINK("e:\Disc 1\MP 200\","*"&K1018&"*"&".PDF"). Cell K1018 contains part of the file name. When I click on the Hyperlink it takes me to the subfolder but it is not opening the image file. Do I have to use any other character for the wild card? Any help in this regard is very much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a Hyperlink as part of a macro | New Users to Excel | |||
| Can not open a file from hyperlink set | Links and Linking in Excel | |||
| excel - create a macro to use cell text as part of a file name | New Users to Excel | |||
| How to create hyperlink from 2 cells, then open Word | Excel Worksheet Functions | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Threaded Mode
