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.
The only problem I have with this method is I can only do one folder at a
time. I usually add another column to the table and copy the folder name
into it on every row.
Also the three letter abbreviation for file type is not as useful as the
windows explorer file type column.
Tom Turak
-----Original Message-----
From: Robert Lendrim [mailto:[log in to unmask]]
Sent: Monday, June 17, 2002 3:49 PM
I have a large number of files in a folder. I would like to put that
list of files (names and possibly file details) in an Excel spreadsheet.
Does anybody know of a way to do that?
Thanks, Bob
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|