| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup worksheetfunction
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup worksheetfunction
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup worksheetfunction
The file must be open:
application.worksheetfunction.vlookup(emb,Range("[filename.xls]sheet1!A1:AB3 00"),5,false) -- Regards, Tom Ogilvy "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup worksheetfunction
Whoops, forgot my smiley face <g
Come on Bob - No way! ;-) -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WorksheetFunction.Vlookup | Excel Discussion (Misc queries) | |||
| Worksheetfunction.vlookup and #value error | Excel Worksheet Functions | |||
| application.worksheetfunction.vlookup | Excel Programming | |||
| Unable to get the Vlookup Property of the WorkSheetFunction Class | Excel Programming | |||
| worksheetfunction.vlookup? | Excel Programming | |||
Linear Mode
