Dynamic reference to file names

[orit]

I'm storing files on a defined pattern, for example:
D:\Project\date\test_date.xls
The "D:\Project\" part of the path is set, then the file will be saved in a folder which will be named according the date it was saved, for example: "061003" for October 3rd 2006 (the format of the date doesn't matter), then the file name will be built from a set string, for example: "test_" and following that the file date, so the file path and name today will be: D:\Project\061003\test_061003.xls.
I want to create link to different files dynamically, using the date as variant. How can I do that?

Thanks a lot

 

[erik.van.geit]

Hi,

do you mean a hyperlink
take a look then in the helpfiles for that function

  A           B            
1 D:\Project\ 061003       
2 test_       test_061003  
3 file_       file_061003  
4                          
5 other_      other_061003 

test
[Table-It] version 06 by Erik Van Geit

RANGE FORMULA (1st cell)
B2:B5 =IF(A2="","",HYPERLINK($A$1&$B$1&"\"&A2&$B$1&".xls",A2&$B$1))

[Table-It] version 06 by Erik Van Geit

kind regards,
Erik

 

[orit]

Perfect, Thanks