Path: news.nzbot.com!not-for-mail
From: "Lars Blume" <lars.blume@ete.ericsson.se>
Newsgroups: alt.music
Subject: Re: Catalog my CD collection
Date: Wed, 22 Oct 2003 09:00:59 +0200
Organization: Ericsson
Lines: 36
Message-ID: <bn59ti$74r$1@newstree.wise.edt.ericsson.se>
References: <v3alb.15803$W77.5000@bignews6.bellsouth.net>
NNTP-Posting-Host: efg3400g6a1os3o.lmera.ericsson.se
X-Trace: newstree.wise.edt.ericsson.se 1066806002 7323 150.132.83.109 (22 Oct 2003 07:00:02 GMT)
X-Complaints-To: abuse@ericsson.se
NNTP-Posting-Date: Wed, 22 Oct 2003 07:00:02 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Xref: news.nzbot.com alt.music:285
Piece of cake -:)
Step 1. List the MP-3 directory to a text file. Write in a DOS window: dir
C:\searchpath....\*.mp3 /b /s >> C:\path\my_mp3.txt
All your MP-3 files will now be listed with the complete searchpath in a
textfile my_mp3.txt
Step 2. Start EXCEL and open your textfile from EXCEL. A dialog window pops
up. Klick Delimited and Next.
In the next pop-up: Under Delimiters klick other and type a backslash \ in
the window. Klick Next and then klick Finish.
Step 3. Under Tools, use the Filter -> Auto filter function.
Now if you want to simplify the procedure, write a batch file to execute the
DOS-command and associate the batch file with an icon Also make an
EXCEL-macro to do the EXCEL-job and associate the macro to a button on one
of the toolbars. You will then be able to make the list by klicking on one
icon and klick one button in EXCEL.
Good luck!!
/Lars
"Chuck S" <chukjunk@bellsouth.net> wrote in message
news:v3alb.15803$W77.5000@bignews6.bellsouth.net...
> I have made master copies of my CD's ( in mp3 format) and want to catalog
> them , I have excel but don't know how to use it to catalog my current
> collection. I have over 3200 titles . Is there someone here that can send
me
> to a site or give me a little help in how to make a list in excel .
>
>
|
|