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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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.

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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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

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

"rea" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

--
Regards,
Tom Ogilvy


"rea" wrote:

> 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
>
>