[AccessD] OT - Need Excel macro

Kathryn Bassett kathryn at bassett.net
Sun Sep 21 21:12:04 CDT 2003


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  



More information about the AccessD mailing list