Thread: VLOOKUP into another workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L Mehl L Mehl is offline
external usenet poster
  
Posts: 73
Default VLOOKUP into another workbook
Hello --

Can someone show me the format for using VLOOKUP in VBA to get a value from
an xls in another folder?

In a worksheet
=VLOOKUP(1,TA_TestScript.xls!TestCases,2,FALSE)

TA_TestScript.xls is the closed file

works, but I can't figure out the correct combination of [ ], " ", etc. to
make it reference an xls in another folder, using VBA.

Thanks for any help.

Larry Mehl


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004


Reply With QuoteReply With Quote