[mso] Re: CD/DVD Dir & filename info

  • From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Sun, 20 Jul 2003 12:17:16 -0500

Greg created a cool utility, File Cataloger, that'll hyperlink all those
files into a Word doc. It'll run quickly. You can add the CD number/date to
the table as you do each...then just put the tables together and sort. You
can even add notes. Then just open the file to find what you need. 

Granted, that much info is a lot for a Word table...but you can forget the
table structure and use the line sort...like Greg does when he uses it to
collect/sort many thousands of server logs.

Or you might find his new Directory Catalog more convenient? It replicates
Windows directory tree structure in an expanded format so you can see
everything you have without having to click to expand anything.

You can find these free utilities at: www.mousetrax.com/downloads.html.

Dian Chapman
Technical Consultant
& Microsoft MVP

Free Word Tips & Tricks eBook: http://www.mousetrax.com/books.html
Free Tutorial site: http://www.mousetrax.com/techpage.html
Free Support Ezine: http://www.mousetrax.com/techtrax/
  


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Sunday, July 20, 2003 11:50 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] CD/DVD Dir & filename info

Has anyone successfully utilized Excel or Access to read the filenames on a
CD/DVD and capture the following information with that file? I.e.,  for
example:

Smyth.Ged 4/4/99   12:38 R-H- F:\SmythFamily
Bankin.Bir   8/22/98   4:58 RSH-- F:\System\Births

And so on?

Obviously, it is for recording the filenames of my genealogy data. I was
surprised to to realize I have amassed over 400 CD-Rs (or DVD-Rs) of
genealogy data. If I could somehow get a text/Ascii file of all of the
filenames, I could search to see which CD/DVD a file may be on. Obviously,
each CD/DVD will have to have its own unique name to do this. I have named
them A, B, C, D, ...Z, AA, BB, and so on. At the time I thought it was
efficient.

The DIR command does not reveal the attributes, and the ATTRIB command does
not show creation/edited dates. Can I easily blend the two commands to get
the best of both worlds?

Thank you.

Robert 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: