VBA Lookup from closed workbook

[kerstine03]

Hi All!

Would like to ask for help on what I'm currently working.


Sales_Conso.xlsm is my consolidating workbook. Range D8 to last column, contains the file names of the workbook where my table array will be.
What I wanted to achieve is:
If range D11 to last row is blank, it will open the workbook specified based on the file name on D8 and will apply the vlookup formula.
Lookup_Value = Sales_Conso.xlsm range B8 to last row
Table_Array = Filename on D8 to last column, range B7 to last cell with value
Col_index_num = 10

Hope someone could help.