I am using VLOOKUP in workbook to retrieve information from other files.
My formula looks like:
=VLOOKUP(B10,'C:\Documents and Settings\alopez\Desktop\Excel
Test\[Source1.xls]Sheet1'!$A$3:$B$7,2,FALSE)

A want to be able to retrieve information froma different type depending on
the value of cell. IE If the user enters a date in cell A1, I can form a file
name using a prefix and the date. Lets say the user enters 12/05/2007. I will
create the filename Source-12-05-2007.xls.

How do I pass automatically this value to the VLOOKUP function w/o having to
update the hardcoded value of the file name???

Regards