Linking Cells to a file that changes names

C

Carlmac4

I am currently trying to link cells to a file that changes names weekly. I
don't know if I can do this with wildcards or not. Any help in this matter
would be greatly appreciated.
 
G

Gary L Brown

Put the full file name in a cell
for example, in A1 put
C:\Temp\MyFile.xls
In another cell, enter the following equation...
=Hyperlink(A1)
Now you just need to change the value of A1 each week.
HTH,
 
Top