Drive letter from cell reference

Hi All,

I need to use something similar to the below code to take the contents of cell D7 on sheet T Dash (In workbook Overview which is where the macro is running) to afford the drive letter:

Workbooks.Open Filename:= _ "W:\Revenue Forecast\Pet stores.xlsx"

I tried to use;

Workbooks.Open Filename:= _
Range("D7").Value &":\Revenue Forecast\Pet stores.xlsx"

but it didn't work.

Any ideas