MP3 files and Excel spreadsheet

[Guest]

I have a file on my desktop called "magmusic". it contains over 700 songs.
how do i list them alphabetically in an Excel spreadsheet.
EX. TITLE ARTIST
ANY HELP WOULD SURELY BE APPRECIATED. THANKS.

 

[VBA Noob]

Try the attached link

http://www.j-walk.com/ss/excel/tips/tip103.htm

VBA Noob

 

[Guest]

What file format is the file on your desk top?

you could try and 'Data'.....'Data import'....follow the steps to import the
data into excel once you have it in it should just be a matter of doing a
'data'...'sort' using the song title as the key sort field.

 

[Gord Dibben]

I'm betting it is not a "file" but rather a "folder".

Noob has given you a good link to John's site.


Gord Dibben MS Excel MVP