i think there is a confusion on terms. You can either read/query two
different ways

1) If you open the CSV file it will become a worksheet. Yo can use a
number of different methods to retrievve data from the CVS file.
vlookup() is one of these methods. Yo can also use the find method from
VBA to get data from the worksheet

2) If yo don't want to open the CSV file as a worksheet then you can
use the ADO method like arjen code.


Hope this clarifies the problem so a novice will understand the
differences.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=192203

http://www.thecodecage.com/forumz