Pull! Question with N/A and REF errors

[enigmaes]

I need to do a Vlookup. I used Indirect.ext for one application, which worked great, but I am trying to get information from over 2000 files...impossible to open that many, AND the .ext doesn't work with vlookup. If it runs until Christmas, it'll still be faster than I am. In a minimized version of this (5 files, 5 vlookups), I am using the following:

=Vlookup("*search*",Pull('c:\direc\[file.csv]sheet1'!$bx$1:$bx$2000), 1, False)

Any idea what I'm missing?

Pull is installed as module 1.

I ran a debug and it stopped on this line
Set xlwb = xlapp.Workbooks.Add 'needed by .ExecuteExcel4Macro

Help? TIA.

 

[enigmaes]

OK - I have been working with this most of the day. Hoping it's something really simple.

First: These are A1 and A2
(A1) =pull("'"&A2)

(A2) C:\temp\[7770.xlsx]777'!$a2

<colgroup><col width="64"></colgroup><tbody>
</tbody>

In file 7770.xlsx, sheet 777, i have

(A1) testing
(A2) it worked

Checked syntax, checked drive/path for length. PULL is in module 1. Help?

 

[enigmaes]

GOT IT!! Thanks!