How do I use a string to access a named range on another workbook.

D

Dave.ca

I need to use Vlookup to find a specific piece of data on another workbook,
but it has to update which sheet it looks to depending on the date. ex:
"=VLOOKUP(C5, 'I:\Tools2\[Raison.xls]ByIndustry_2004-08-31'!DataTable, 9,
FALSE)"

Where "ByIndustry_" should be followed by the current date...

I haven't been able to make this work when the other sheet is not open, with
or without VBA.

Thanks for any help.
 
Top