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

Can you hyperlink to a hyperlink? 1
Macro File Names 2
How to create a hyperlink to open a file with part of the name 4
Hyperlink to the meat of a cell 4
File Names within a Macro Function 2
Excel hyperlink to another open Excel file - wants to reopen file 1
HYPERLINK Worksheet Function 3
Hyperlink problem to cell in same workbook 4

Top