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