From the top of my head you have 2 options:
(1) connect tothe text file via ado/dao connection object and upen it
up as a recordset. Then do the things you want.
(2) insert a querytable (XL2002/03 that would be DataImport External
DataNew Database Query, XL 2007/10 that would be InsertTableFrom
External Data Sourse (or something like that)). Then you can have your
ordinary vlookups pull the data from the query/table. With this one
pretty much no coding involved.

A.

On Feb 15, 5:39*am, " wrote:
Hi All,
I have read through all post on net in this weekend about my problem,
however I could not get right answer. I have a text file which is
named as stafflist with user id numbers, name and positions. Let's say
as below
1039 * *Tony Adwards * *SUP-V
1277 * *John Philips * *DRGSM-V
1326 * *Ken Through * * DRGSM-V
......

That is the file with 5000 users. I do not want to keep those user
details in excel file, because it takes a lot of space.Is there any
way to write a code to lookup value from that text file. Let's say
once enter in the id number( 1039 ) textbox1 *textbox2 to display the
name and textbox3 display the position.
Thank you for the help
Baha