dear all...,
dear mr patric,

thanks for the tips, the macro recorder is new things for me, i can us
it in many of my importing process ;)

but for my need in importing source datas as i attached (RTE....txt) t
excel format it's not easy for me, because as you see the source i
dynamic

i'd like to use loop-things so my process go maybe like this

..
read line:

if belong to RTE=100 -- write RTE=100, write all the array data to ro
data in excel: for the ASP, ATTEMPT....(until) TRAFFIC

if still the datas belong to RTE=100 -- write RTE=100, write all th
array datas again,

if RTE <100, RTE=XXX -- write RTE=XXX, write all the array data
belong to RTE=XXX

and so on like that until the datas is fineshed

sorry, i'm just an amateur in vba, but if i can see, sample coding
believe i can modify it

thanks for ur kind

dw

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