Hi there,

This thread was posted by Larry Mehl in Excel Charting forum by mistak
so he
didn't get any replies. As i'm after the same thing exactly , i thouhg
to repost the
same question.

Cheers
AnA

"Hello --

Can someone show me the format for using VLOOKUP in VBA to get a valu
from
a closed xls file?

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 work in VBA.

Thanks for any help.

Larry Mehl

--
alk100
-----------------------------------------------------------------------
alk1000's Profile: http://www.excelforum.com/member.php...fo&userid=1497
View this thread: http://www.excelforum.com/showthread.php?threadid=26596