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?

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?