[AccessD] OT - Need Excel macro

William Hindman
So, then, to every man his chance -- to every man, regardless of his birth,
his shining golden opportunity -- to every man his right to live, to work,
to be himself, to become whatever his manhood and his vision can combine to
make him -- this, seeker, is the promise of America.
-- Thomas Wolfe



----- Original Message ----- 
From: "Kathryn Bassett" <kathryn at bassett.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, September 21, 2003 10:12 PM
Subject: [AccessD] OT - Need Excel macro


> I don't use Excel on a regular basis, and even in QuattroPro, I don't use
macros. I was wondering if one of you are good with Excel (2000) macros, can
make me a macro to do the following - if it's possible to automate what I
want to do.
>
> I will have files with a name pattern of output1928.txt - the 1928 can be
any four numbers (it is a 24hr time). I'm putting a sample file at:
> http://www.ourmailinglist.org/misc/output1928.txt
>
> What I currently do manually is:
>
> (first half)
> open Excel and File > Open, navigate to the text file, and open it. That
starts the Text Import Wizard.
> I click next, as I use the default "delimited"
> choose comma
> click next
> skip first two
> third, fifth, and seventh are text, fourth and sixth are general
> finish
>
> (second half)
> Next, I insert a row at the top, and label them (lowercase)
> activity
> bib
> timetext
> day
> checkpoint
>
> (last)
> save as Excel, with same prefix name output1928.xls
>
> So, is there a way to do at least the first half, but preferably both
halves, using a macro?
>
> (Remember the AC100 race that you all have helped me with? Well, this is
what I have to do with the raw data before imorting it to the database.)
>
> If it can't be done with a macro, that's ok as I have my notes. But if it
can, it will be a big help as I have to do this routing about two dozen
times during the race.
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>