N
nick
is there a way of generating a list in excel from songs i have saved on my d
drive?
drive?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
If all of your files are in this format, I have one
artist - title.mp3
artist - title.mp3
N
nick
i do have them in that format
Don Guillett said:If all of your files are in this format, I have one
artist - title.mp3
G
Gord Dibben
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
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
D
Don Guillett
Then send me, OFF list your email and I will send.
I will NOT respond to any request made ON list.
I will NOT respond to any request made ON list.
C
CLR
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
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
G
Gord Dibben
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
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
N
nick
gord...
went to the site and did as you instructed and can't seem to find the TM in
the worksheet menu bar
went to the site and did as you instructed and can't seem to find the TM in
the worksheet menu bar
N
nick
this is my first time on here and not quite sure how to send you off list my
email address
email address
D
Dave O
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
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
G
Gord Dibben
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
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
N
nick
got it. thanks for the help
Gord Dibben said: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
J
Jim Cone
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
[email protected]
"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
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
[email protected]
"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
D
Dave Peterson
Send a direct email request to Don.
His email address is in his signature--right under his name in his messages.
His email address is in his signature--right under his name in his messages.
M
Max
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 !
R
Robin Hammond
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
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
G
Gord Dibben
Thanks for posting this Robin.
Didn't know(or forgot) about John's MP3-specific utility.
Gord
Didn't know(or forgot) about John's MP3-specific utility.
Gord