vlookup worksheetfunction
workbooks("c:\lists\filename.xls")
Come on Bob - No way!
--
Regards,
Tom Ogilvy
"Bob Phillips" wrote in message
...
application.worksheetfunction.vlookup(emb,workbook s("c:\lists\filename.xls")
.worksheets("sheet1").range("A1:AB300"),5,false)
don'tknow what emb is.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"ben" wrote in message
...
What is the proper syntax for using
application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:
AB300,5,false)
Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open
|