Import, format, convert, print VBA module

[rinser]

Hi All,

I was wondering if its possible to build a module that would do the following: a) import a txt file to excel formatting it as text.
b) then in column D would remove the preceding space.
c) then convert data in D according to a separately kept Conversion table (or conversion table could be integrated into the code) and print conversion results into column J.
d) the last step is to print/copy columns A and J so that it looks like the final table in Sheet2.
Here are files attached.
sample data.txt
sample data.xls
conversion table.xls
To summarize I need to go from a txt file like the one attached and arrive at the table in Sheet2 of xls file attached.

Thank you!

[excel_1982]

This code might help.... You will have to change according to your needs

Please Login or Register  to view this content.

[shg]

Please edit your post to add code tags.

[excel_1982]

@shg

Sorry about that. Change made

[shg]

Please edit your post to use code tags, not quote tags. The forum rules tell all.

[ravishankar]

Hi
Save the attached file in the folder containing sample text files to be imported. run the macro.
Ravi

[rinser]

Hi guys,

I am analyzing the proposed solutions and will report back with the results.

Thank you!

[rinser]

Hi ravishankar,

When I run the macro on my pc it throws an error and points in yellow to this line:

Please Login or Register  to view this content.

Do you know what shall I change?

Cheers,
Sergiu

[rinser]

Hi guys,

I am afraid none of the solutions is working or I don't know how to apply them. The solution of ravishankar is very close but part of the code is hidden it seems and I can't figure out how the two subprocedures work and how to call them both. I am closing the thread and will start a new one for another module similar to this one but a bit more complex and maybe adapt that one to solve also the needs in this one.

Thanks to all for the input and time!
Cheers.