Date within file name in cell

[Slade]

Hi

I am tying to insert a date from another cell on another sheet to a cell that contains a filename that must have a date. it does get the value but changes it to a random number. how can i fix this?

Sheet1, Cell A1 is the date: 20110804
Sheet2, Cell A1 is the filename with date:

Formula is:"=IA_Hoops__"&DATE!$B$3&".csv"
Value that i get is: ="IA_Hoops__40759.6666666667.csv"
The "40759.6666666667" is suppose to be the date from A1 sheet1

Tnx

 

[CWatts]

CELL("filename") was not meant for you to substitute anything. You literally have to write:

CELL("filename")
not
CELL("c:\x.txt") or anything else.

If you type =CELL("filename") into a cell you'll see what I mean.

 

[AdityaTyagi]

input means ,where do u get file name and which format..

 

[Slade]

Ooo ok sorry. For testing i use a file directly on my c:\ drive. the exact root is C:\dir20110808075125.txt. Other wise the other files are also txt files just on a server but the code will stay the same because it is a mapped drive.