Forgot to remind you to save the file as a microsoft workbook.  Excel will
default to keeping it as a text file if you don't.

-----Original Message-----
From: Tom Turak [mailto:[log in to unmask]]
Sent: Tuesday, June 18, 2002 1:02 PM


Pretty simple really.  Open a dos box and move to your folder, for example,
cd "\my documents"

The change directory "cd" command does not work well with long names so the
quotes are required.

Enter the command

dir >test.txt

where the file can have any name you like, but an ending of txt is most
convenient for excel.

Go into excel and open the file test.txt and you will get the import wizard
immediately. Change the "start import on row" field from 1 to 8.  Click next
twice.  Click on the first column heading where it says 'general', and
choose 'don't import column'. If you think you may want to sort by file
type, click finish now, otherwise, click on the second column heading where
it says 'general', and choose 'don't import column'. Click finish.  Insert a
row at the top and put in column titles.  go to the bottom and delete the
last two rows.

Your table is almost done.  If you need to use the time stamp, add this
formula to a new column
=TIMEVALUE(LEFT(c18,SEARCH(RIGHT(c18,1),c18)-1))
then change this new column's numeric format to a time style.

This will convert the text 2:48p to a value you can use to compute elapsed
time, etc.

Tom Turak

                Curious about the people moderating your
                   messages? Visit our staff web site:
                    http://freepctech.com/staff.shtml