I am trying to do vlookup in a macro. Is there any way I can specify a table from a sheet in a workbook that is not open for second argument of vlookup?
For this format
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC4,[current_file.xls]overall!R2C1:R1000C15,4,FALSE)"
I have to have current_file.xls open
It gave me errors when I tried this
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC4,[E:\folder 1\folder 2\current_file.xls]overall!R2C1:R1000C15,4,FALSE)"
What is the correct syntax to specify this file in vlookup so that I dont have to have that file open?
Thanks,
Jay
Bookmarks