I have daily excel files with dates as names - for example 07292015_abc.xls. (29th July 2015 file)
How do i write a vlookup function where the date is embedded in the formula?

I want to do the following:
type a date in a particular place and use this date as a variable in the vlookup formula:
=VLOOKUP("inr curncy",'C:\THIS DIR\[07292015_FILE.xls]SHEET (2)'!A:C,3,0)

i type date, in say cell A1, and convert the date to text by =TEXT(A1,"MMDDYYYY"); but am not able to use this in the vlookup function.

By making 07292015 dynamic i would not have to type in the formula for every date.

Thanks for the help.