| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a file that changes names daily
I have a button which hyperlinks to another excel spreadsheet. Let's call it
XYZ_15oct08.xls, Today it is labled XYZ_16oct08.xls, I thought I might be able to hyperlink to XYZ_(insert wildcard here) and get it to work regardless when or what the file name is changed to, however, I cannot seem to get any of the wildcards to do this. I tried ?, *, %, ~, any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink to a file that changes names daily
Try
=HYPERLINK("C:\YourPathHere\XYZ_"&TEXT(TODAY(),"dd mmmyy")&".xls") "sonarmark" wrote: I have a button which hyperlinks to another excel spreadsheet. Let's call it XYZ_15oct08.xls, Today it is labled XYZ_16oct08.xls, I thought I might be able to hyperlink to XYZ_(insert wildcard here) and get it to work regardless when or what the file name is changed to, however, I cannot seem to get any of the wildcards to do this. I tried ?, *, %, ~, any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
| Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
| Saveing workbook to a file as todays date daily | Excel Worksheet Functions | |||
| EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
