copy from multicolumn .txt document

[rea]

can somebody help me...
i have a .txt wich holds data in 5 or six colums separated with sign
",".
i manage to copy data from .txt wich holds only one column, but i dont
know how to solve this problem.i need to copy only 1 column from .txt
(lets say third) to .xls .
the number of rows is huge.

 

[NickHK]

You can either change the extension to .csv and Excel should open it
normally.
Or in Excel, go File>Open and follow the steps.
Either way, you can then copy and work the data in Excel.

NickHK

 

[rea]

it is one solution, but i need to have a code, becuse mz txt is
generated from another program wich recives data from rs232... so it is
a bit complicated,but the point is that i need to code.

 

[rea]

it is one solution, but i need to have a code, becuse mz txt is
generated from another program wich recives data from rs232... so it is
a bit complicated,but the point is that i need to code.

 

[NickHK]

Well, record the macro of the Open file option and see the code.

As for the rename, use
Name "mz.txt" As "mz.csv"
adding paths as required.

NickHK

 

[rea]

thnx, but it wont solve my problem for good.
because i need to use variables.i am planning to expand the main code,
but i am missing small piece of code wich would put the selector to a
third colmn of .txt
thnx

 

[NickHK]

If you can do it manually, you can (normally) generate the code for the
actions.
Show the code you get and explain why it is not the desired result.

NickHK

 

[Guest]

You can also look at this page an perhaps adapt it to your requirements

http://www.cpearson.com/excel/imptext.htm import/export text files