Import txt macro with range

[alvertis]

Hello, I have tried lots of things but, no luck.
I want a macro to insert, lots of txt files into an xls.
Some files on the same sheet, some not.
Each value on diferent cell
I can't figure out how to put each txt where I want it.
etc 1.txt at cell C5, 2.txt at k5 and 3.txt at O5, and other txt at other sheets.
Thanks a lot.

Please Login or Register  to view this content.

[mrice]

Try something like this

Please Login or Register  to view this content.

[alvertis]

thanks a lot, I added a few things and worked great