Linking Cells to a file that changes names
 

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.

Linking Cells to a file that changes names
 

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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Carlmac4" wrote:

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.