song list

nick

unread,

Jul 4, 2005, 6:19:01 PM7/4/05

to

is there a way of generating a list in excel from songs i have saved on my d
drive?

Don Guillett

unread,

Jul 4, 2005, 6:26:18 PM7/4/05

to

If all of your files are in this format, I have one

artist - title.mp3

--
Don Guillett
SalesAid Software
don...@281.com
"nick" <ni...@discussions.microsoft.com> wrote in message
news:0916245E-11D0-4946...@microsoft.com...

nick

unread,

Jul 4, 2005, 6:36:04 PM7/4/05

to

i do have them in that format

Gord Dibben

unread,

Jul 4, 2005, 6:52:24 PM7/4/05

to

Nick

One method to pull directly to Excel is to use Tushar Mehta's Excel Add-in.
This allows filtering and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory Listing.

Download the ZIP file and un-zip to your Office\Library folder.

Go to Tools>Add-ins and checkmark Tushar's add-in.

TM will show up on your Worksheet Menu Bar.

Click it and browse to the folder of songs.

Gord Dibben Excel MVP

On Mon, 4 Jul 2005 15:19:01 -0700, "nick" <ni...@discussions.microsoft.com>
wrote:

Don Guillett

unread,

Jul 4, 2005, 6:56:54 PM7/4/05

to

Then send me, OFF list your email and I will send.
I will NOT respond to any request made ON list.

--
Don Guillett
SalesAid Software
don...@281.com
"nick" <ni...@discussions.microsoft.com> wrote in message

news:E4E93205-1B40-4C0B...@microsoft.com...

CLR

unread,

Jul 4, 2005, 7:03:32 PM7/4/05

to

Personally, I prefer to use Jim Cone's fine Add-in called "ListFiles" for
this sort of thing..........
It returns the filename, filetype, filesize, date, a total count of the
files, and a hyperlink to each file.

Vaya con Dios,
Chuck, CABGx3

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:49fjc1tcsdcfss364...@4ax.com...

Gord Dibben

unread,

Jul 4, 2005, 7:32:00 PM7/4/05

to

Chuck

Post the URL so's we can download and try Jim's fine Add-in.

Or change the obvious in my email address and send me a copy.

Thanks, Gord

nick

unread,

Jul 4, 2005, 7:46:01 PM7/4/05

to

gord...

went to the site and did as you instructed and can't seem to find the TM in
the worksheet menu bar

nick

unread,

Jul 4, 2005, 7:48:01 PM7/4/05

to

this is my first time on here and not quite sure how to send you off list my
email address

Dave O

unread,

Jul 4, 2005, 7:50:47 PM7/4/05

to

Alternatively, for the DOS holdovers:
1. Open a command prompt window, and change to the proper drive
2. Type DIR > mp3list.txt and press Enter
3. Open mp3list.txt from Excel

Gord Dibben

unread,

Jul 4, 2005, 8:03:46 PM7/4/05

to

If you have extracted Directory.xla to your Office\Library folder and loaded
it through Tools>Add-ins you should see TM just to the right of Help on the
menu.

Re-trace.....perhaps you missed a step.

With Excel closed..........

1. Download the ZIP file from Tushar's site.

2. Extract to Libray

3. Open Excel and go to Tools>Add-ins.

4. Find "Directory"(no quotes) and checkmark the option box and OK.

Gord

On Mon, 4 Jul 2005 16:46:01 -0700, "nick" <ni...@discussions.microsoft.com>

nick

unread,

Jul 4, 2005, 8:22:08 PM7/4/05

to

got it. thanks for the help

Jim Cone

unread,

Jul 4, 2005, 8:38:24 PM7/4/05

to

Gord,

Just sent you a copy in a separate email.
No URL in existence yet so...
For others interested, the add-in is free upon direct request.
Remove XXX from my email address.

Jim Cone
San Francisco, USA
jim.c...@rcn.comXXX

"Gord Dibben" <gorddibbATshawDOTca> wrote in message

news:5jhjc1hoouq5sh2ua...@4ax.com...

Dave Peterson

unread,

Jul 4, 2005, 9:11:47 PM7/4/05

to

Send a direct email request to Don.

His email address is in his signature--right under his name in his messages.

--

Dave Peterson

Max

unread,

Jul 4, 2005, 9:34:32 PM7/4/05

to

"CLR" wrote

> Personally, I prefer to use Jim Cone's fine Add-in called "ListFiles" for
> this sort of thing..........

Same here, I'm also using Jim's product.
It's a real blast <g>, with excellent results !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

Robin Hammond

unread,

Jul 5, 2005, 4:55:59 AM7/5/05

to

nothing wrong with the other suggestions but John Walkenbach has also done
this specifically for mp3s, adding a twist of using namespace information to
extract details like bit rate and song length.
http://j-walk.com/ss/excel/tips/tip103.htm

Robin Hammond
www.enhanceddatasystems.com

"nick" <ni...@discussions.microsoft.com> wrote in message
news:0916245E-11D0-4946...@microsoft.com...

Gord Dibben

unread,

Jul 5, 2005, 1:42:10 PM7/5/05

to

Thanks for posting this Robin.

Didn't know(or forgot) about John's MP3-specific utility.

Gord