song list
 

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

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

artist - title.mp3


--
Don Guillett
SalesAid Software

"nick" wrote in message
...
is there a way of generating a list in excel from songs i have saved on my
d
drive?

i do have them in that format

"Don Guillett" wrote:

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

artist - title.mp3


--
Don Guillett
SalesAid Software

"nick" wrote in message
...
is there a way of generating a list in excel from songs i have saved on my
d
drive?

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

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

Go to ToolsAdd-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"
wrote:

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

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

"nick" wrote in message
...
i do have them in that format

"Don Guillett" wrote:

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

artist - title.mp3


--
Don Guillett
SalesAid Software

"nick" wrote in message
...
is there a way of generating a list in excel from songs i have saved
on my
d
drive?

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

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

Go to ToolsAdd-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"
wrote:

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

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

On Mon, 4 Jul 2005 19:03:32 -0400, "CLR" wrote:

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

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

Go to ToolsAdd-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"
wrote:

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

gord...

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

"Gord Dibben" wrote:

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

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

Go to ToolsAdd-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"
wrote:

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

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

"Don Guillett" wrote:

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

"nick" wrote in message
...
i do have them in that format

"Don Guillett" wrote:

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

artist - title.mp3


--
Don Guillett
SalesAid Software

"nick" wrote in message
...
is there a way of generating a list in excel from songs i have saved
on my
d
drive?

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

If you have extracted Directory.xla to your Office\Library folder and loaded
it through ToolsAdd-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 ToolsAdd-ins.

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


Gord

On Mon, 4 Jul 2005 16:46:01 -0700, "nick"
wrote:

gord...

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

"Gord Dibben" wrote:

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

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

Go to ToolsAdd-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"
wrote:

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

got it. thanks for the help

"Gord Dibben" wrote:

If you have extracted Directory.xla to your Office\Library folder and loaded
it through ToolsAdd-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 ToolsAdd-ins.

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


Gord

On Mon, 4 Jul 2005 16:46:01 -0700, "nick"
wrote:

gord...

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

"Gord Dibben" wrote:

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

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

Go to ToolsAdd-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"
wrote:

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

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
XX


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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



On Mon, 4 Jul 2005 19:03:32 -0400, "CLR" wrote:
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

Send a direct email request to Don.

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

nick wrote:

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

"Don Guillett" wrote:

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

"nick" wrote in message
...
i do have them in that format

"Don Guillett" wrote:

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

artist - title.mp3


--
Don Guillett
SalesAid Software

"nick" wrote in message
...
is there a way of generating a list in excel from songs i have saved
on my
d
drive?







--

Dave Peterson

"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 <atyahoo<dotcom
----

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" wrote in message
...
is there a way of generating a list in excel from songs i have saved on my
d
drive?

Thanks for posting this Robin.

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


Gord

On Tue, 5 Jul 2005 16:55:59 +0800, "Robin Hammond"
wrote:

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" wrote in message
...
is there a way of generating a list in excel from songs i have saved on my
d
drive?