vlookup worksheetfunction

[Guest]

What is the proper syntax for using

application.worksheetfunction.vlookup(emb,"c:\lists\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

 

[Bob Phillips]

application.worksheetfunction.vlookup(emb,workbooks("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)

 

[Tom Ogilvy]

The file must be open:

application.worksheetfunction.vlookup(emb,Range("[filename.xls]sheet1!A1:AB3
00"),5,false)

 

[Tom Ogilvy]

workbooks("c:\lists\filename.xls")

Come on Bob - No way!

 

[Tom Ogilvy]

Whoops, forgot my smiley face <g>

Come on Bob - No way! ;-)