Hyperlink to a file that changes names daily

S

sonarmark

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
How to create a hyperlink to open a file with part of the name 4
Excel hyperlink "Cannot open the specified file" 0
update the hyperlink in file after changing the file name 3
Linking to Workbooks that Change Name Daily 3
Hyperlink to workbook location 0
Linking Daily Workbooks 1
Copying a Column of Formulas between Excel Files 6

Top