assuming i have a txt file into a dir server here is the global dim:

Global Const PATH = "\\GCD01F4500\DATI\PUBBLICA\INPS\CARTEL1.TXT"

Is possible with a vba macro ,to make a vlooup into sheet (attached)
with the index in column A and retrive the result of match into column
B

Note: into txt the first line is the header of record. Use this txtx
file similar a MDB Access, because is shared from many user.

ziped file: http://www.mytempdir.com/644325


--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=539405