🚀 go-pugleaf

"Mike Cocker" <cockermike@yahoo.com> ha scritto nel messaggio
news:1069266910.710065@ns2.worldwithoutwire.com...
> Hi all,
>
> I have a comma delimited file that I normally manipulate in Excel, but I
> really want to speed things up by automating it. With some help from this
> newsgroup, I think I can do this in VB.
>
> The comma delimited file (http://www.swandust.com/rpt_cdc_new.txt) needs
to
> be converted into a very similar file
> (http://www.swandust.com/rpt_cdc_changed.txt). I don't want to make a
> lengthy post, so I'll take baby steps first and just do a portion of what
is
> needed for rpt_cdc_changed. Once this is accomplished, I can explain the
> remaining steps in a future post. I think the easiest way to explain what
I
> did is to walk you through the steps I take in Excel to make
> rpt_cdc_changed.txt.
>
> 1) Import rpt_cdc_new.txt into Excel.
> 2) Insert a column titled "SortCode" inbetween "Stop" and "Week".
> 3) The formula in the "SortCode" column is something like
> =CONCATENATE(E2,IF(C2="a","AC",IF(C2="b","BD",IF(C2="c","AC","BD"))),D2)
> 4) Create 5 rows after "Cust No" titled "DelType", Route Code", "Seq1" and
> "Seq2"
>
> If VB can automate this with a click of a buttom, I'll be so happy. Thanks
> in advance.
>
> Mike
>

this is an italian group

for your problem
you can use the input command for getting data and print command for putting
data in the new file