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.

--

** Any advice will be greatly appreciated. I need to start in the right
direction then move forward. I'm assuming this will involve several
modules.

--
Thanks,
Himansu

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.



"Himansu" wrote:


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.

--

** Any advice will be greatly appreciated. I need to start in the right
direction then move forward. I'm assuming this will involve several
modules.

--
Thanks,
Himansu