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 .
> >
> >
>
>
|
|