how to use Application.VLookup on close sheet

D

Dan

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 using Application.VLookup

Any idea?

Dan
 
D

Dan

thanks

Mike H said:
You have answers in you other thread

Dan said:
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 using Application.VLookup

Any idea?

Dan
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup from close sheet via VBA 4
Dynamic vlookup from a close workbook 4
Application.VLookup and External files 2
Application.VLookup 11
Can Application.Vlookup access a range in a file which is not open? 4
Application.VLookup Problem... 2
Best way to run Find or Vlookup down specific column in range 2
select case simplification request 7

Top