importing a text file and comparing

[Himansu]

Hello everyone,

I need to create an automated macro that will:

1. Open a workbook (easy).

2. Then prompt to import a text file from the selected
sheet in the workbook (easy).

--
This is the tricky part:

3. The values in the imported file need to be compared to some values
in another base worksheet based on ID numbers.

4. If the values match then another field from the "imported" file is
written
to the base worksheet.

 

[Guest]

Step 3 is wqay to vague to be abble to give any help. I would import text
data into worksheet and save file. Start step three from this point. Later
combine the read text with the other steps.