O
Orhan
Hi,
On H8 cell i have the value "data"
I managed to open the workbook named "data" using Range("H8")
Workbook.open function.
Set Wb2 = Workbooks.Open("c:\data\" & Range("H8") & ".xls")
How can I do the same thing in a vlookup formula?
ActiveCell.FormulaR1C1 =
"=VLOOKUP(RC[-12],data.xls!R2C1:R65008C38,3,FALSE)"
Thanks!
On H8 cell i have the value "data"
I managed to open the workbook named "data" using Range("H8")
Workbook.open function.
Set Wb2 = Workbooks.Open("c:\data\" & Range("H8") & ".xls")
How can I do the same thing in a vlookup formula?
ActiveCell.FormulaR1C1 =
"=VLOOKUP(RC[-12],data.xls!R2C1:R65008C38,3,FALSE)"
Thanks!