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: Thu, 23 Oct 2003 08:44:34 +0200
Organization: Ericsson
Lines: 53
Message-ID: <bn7tar$i1f$1@newstree.wise.edt.ericsson.se>
References: <v3alb.15803$W77.5000@bignews6.bellsouth.net> <bn59ti$74r$1@newstree.wise.edt.ericsson.se>
NNTP-Posting-Host: efg3400g6a1os3o.lmera.ericsson.se
X-Trace: newstree.wise.edt.ericsson.se 1066891419 18479 150.132.83.109 (23 Oct 2003 06:43:39 GMT)
X-Complaints-To: abuse@ericsson.se
NNTP-Posting-Date: Thu, 23 Oct 2003 06:43:39 +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:291
Hi again.
Since you have the MP-3 files on CDs, you must add /ad to the DOS command.
If you do so, the files will be added to your text file for every CD.
dir D:\*.mp3 /b /s /ad >> C:\path\my_mp3.txt should work.
/Lars
"Lars Blume" <lars.blume@ete.ericsson.se> wrote in message
news:bn59ti$74r$1@newstree.wise.edt.ericsson.se...
> 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 .
> >
> >
>
>
|
|