Hyperlink to a file that changes names daily

[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?

 

[~L]

Try

=HYPERLINK("C:\YourPathHere\XYZ_"&TEXT(TODAY(),"ddmmmyy")&".xls")