Can I use Excel as a music database?

[davekingpt]

I'm not happy with the music databases I have seen. I'd like to be able to
have lots of options for sorting music. (Year, composer, performer, genre,
rating) and I'd like to be able to assign a song to more than one genre (one
song may be assigned to rock & jazz & piano solos).

An excel spreadsheet that could access music files would be great. Can excel
reach into "my music"?

 

[joel]

My Music is a folder on your PC usually at a location like this

C:\Documents and Settings\Joel\My Documents\My Music


There are lots of macro functions that can retrieve files from VBA.
The simpliest is DIR()

Folder = "C:\Documents and Settings\Joel\My Documents\My Music\"

FName = dir("*.*")
do while FName <> ""
msgbox(FName)
FName = dir()
loo

 

[Gary''s Student]

Yes

 

[Dave Peterson]

You may want to try John Walkenbach's utility:
http://spreadsheetpage.com/index.php/blog/mp3_file_lister_posted/

 

[davekingpt]

OK, so I know I said "Can I" rather than "How do I......".

I am currently running Excel 2003-Small Business Edition and can't find any
menu item (or any instructions under "help") that would let me reach into "My
Music".

I'm assuming "My Music" would be the appropriate place to store music files.

Can anyone tell me how to set this up so I can not only store and sort music
but also play it? (Do I need to upgrade?)

Thanks.

 

[joel]

Add a hyperlink to the cell(s) by right clicking the cell and th
browsing for the My Music folder