[mso] Read CD files into Excel?
- From: Robert Carneal <carnealr@xxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 06 Jul 2003 11:39:06 -0500
I (and a good deal many others, I suppose) have a library of CD/DVD disks.
Mine is approaching close to 390 disks, nothing gigantic, but easily beyond
my ability to remember what file is on which CD.
If I were to make an Excel app for this, is there a way to do this:
1. Open Excel app.
2. Insert the CD into CD Drive.
3. Goto cell H3 (or whichever cell you want at the time).
4. Copy all filenames on that CD into cell H3.
Why copy all the filenames into ONE cell? Because if I list the filenames
one row at a time, the need for multiple sheets occurs pretty fast.
What do you think? Can the contents of a diskette/CD/DVD/Zip disk/etc be
read into one cell?
What else? Oh, I am using Office 2000, and thus use Excel 2000. Eventually,
I plan to write a macro that will search the filenames for me, and return
the CD name and which slot I keep it in. I can make up an example of what I
would like to do and post it if it helps someone visualize what I am trying
to do. I will keep it small.
Thank you everyone.
Robert Carneal
*************************************************************
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:
