| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup from close sheet via VBA
Thank you
"Mike H" wrote: Hi, You can't do a Vlookup in VBA on a closed workbook so you have options. 1. fleeting open the workbook do the lookup and capture the value or 2. Write a formula to the worksheet capture the value and delete the formula Mike "Dan" wrote: Hi, I managed to do a vlookup from a closed file via: =VLOOKUP(A1,'C:\temp\[test3.xls]Sheet1'!$A$1:$C$18,3,FALSE) but I do not manage to do it by code - I think the problem is that I do not know the sytax to put 'C:\temp\[test3.xls]Sheet1'!$A$1:$C$18 in VBA. Can you help, many thanks, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup on close file | Excel Worksheet Functions | |||
| VLOOKUP Closest Match Not Close Enough | Excel Programming | |||
| Before close - not always deleting sheet- WHY?? | Excel Programming | |||
| Close Hidden Data Sheet | Excel Programming | |||
| Hanging on sheet close | Excel Programming | |||
Threaded Mode
