I retriving data from the machine printer to the txt file using th
RS232 interface , all the data which I am getting is stored in th
*.txt file. I woul like to request for help as to how I can pick th
required data from txt file to excel sheet because if i simply ope
that *.txt file in exl the complete line forms only one cell (String
and numeric values comes in one cell only) where as I would like t
pick the numeric values only from that txt file. Can anybody help me i
writing the macro for that or can advise me as to how I can get th
numeric data only from the txt file to excel file.

I would like to mention one example:- the data I ge from the txt fil
in one cell is

" Total Production of day = 150 Kg."
" Total yarn cuts for 1000 meters = 120"

Now if I open this in excel, The complete one line comes in one cel
only where as in the above two lines I require "1000" from the fir
line and "120" from the second line ( I do not want any alphanumeric t
be picked along with that

--
Message posted from http://www.ExcelForum.com