AW: [AccessD] OT - Need Excel macro

hallo Kathryn,

have u tried using the macro recorder?

alun

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kathryn
Bassett
Gesendet: Montag, 22. September 2003 04:12
An: Access Developers discussion and problem solving
Betreff: [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