VLOOKUP into a closed xls using VBA

L

L Mehl

Hello --

Can someone show me the format for using VLOOKUP in VBA to get a value 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
 
L

L Mehl

Sorry ... wrong group. I have had so many questions on charting recently I
just gravitated to this group.

Re-posted in ...Programming.

Larry Mehl

L Mehl said:
Hello --

Can someone show me the format for using VLOOKUP in VBA to get a value 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
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 into a closed xls using VBA 1
VLOOKUP into another workbook 6
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
using vlookup in vba 10
Drop down list control value in vba 2
Indirect formula errors if file is closed 1
VBA using VLookUp 1
If equation with a VLookUp 3

Top