| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using VLOOKUP from MS Access
I'm openning an excel workbook with many spreadsheets from MS Access by using
the following code: Dim xlapp As New Excel.Application Dim xlbook As New Excel.Workbook Set xlbook = xlapp.Workbooks.Open(strFileName, True) How could I use VLOOKUP to find a needed number from Sheet1 in this workbook? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup from Access | Excel Discussion (Misc queries) | |||
| Using VLOOKUP to look up info from Access | Excel Worksheet Functions | |||
| vlookup from Access db | Links and Linking in Excel | |||
| VLOOKUP from Access Tables | Excel Worksheet Functions | |||
| Vlookup to Access Dbase | Excel Programming | |||
Threaded Mode
