file path and range in formula which reads from a cell

Still having touble defining a file path in a formula that reads from a cell in another sheet.

=VLOOKUP(A23,Data!$B$6,Data!$B$13,FALSE)

Data is the sheet name

B6 contains the file path to another workbook and the range $1:$65536 (this doesn't work)

B13 contains the column number (this works fine)


Can anyone help?

Can you type the value of cell B6 in worksheet "Data" .

B6 = 'R:\weekly information\balanced figures\[midlands.xls]2005'!$1:$65536