Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup from close sheet via VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup from close sheet via VBA
FormualStr = "=VLOOKUP(A1,'C:\temp\[test3.xls]Sheet1'!$A$1:$C$18,3,FALSE)" Range("B1).formula = FormulaStr "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup from close sheet via VBA
Thanks, but that is not what I am after- you are just assigning a formula
via code - nothing to do with vlookup. I want to use Application.VLookup... Thanks "Joel" wrote: FormualStr = "=VLOOKUP(A1,'C:\temp\[test3.xls]Sheet1'!$A$1:$C$18,3,FALSE)" Range("B1).formula = FormulaStr "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup from close sheet via VBA
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 |
#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 |
Reply |
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 |