İmport txt files in excel with VBA codes

[sy43fb]

I wanna import txt files in excel with VBA. I want to import text one by one column.
İf in text file
abcd 123 x+-
32 7 k 698755 then import like below
A B C D E F G H I J K L M N
1 a b c d 1 2 3 x + -
2 3 2 7 k 6 9 8 7 6 5 5

I need to codes. Can anybody help me?

 

[Legacy 456155]

You are very welcome.

 

[sy43fb]

How can I learn VBA. Can you suggest to me Book and VBA tutorial?

 

[Legacy 456155]

For a beginner, pretty much any VBA book will be helpful though I'm sure some would recommend various books over others. Most books, in an attempt to grab the largest audience, seem to only take you so far. Frankly, I find that going through the table of contents in the Visual Basic Reference methodically and taking the time to understand what tools are available has helped me the most. Also, looking at other's code and helping others out on message boards such as this one will expose you to a variety of real world problems. But most important, be creative and have fun!

 

[sy43fb]

Thanks for your suggestions. I think the most important thing beginning

 

[Legacy 456155]

A journey of a thousand miles begins with one help file.