Vlookup from a closed workbook using a macro

[pklimchuk]

Hello here is my Code.

How do i get my vlookup macro to look in a closed workbook.
Or open it and close it once done with the vlookup.



LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
Range("AB2:AB" & LR).FormulaR1C1 = "=VLOOKUP(RC[-3],'[2010 Won Proposals with Comments.xls]RBD NOTES'!R2C1:R65536C3,3,FALSE)"