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.

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.

" wrote:

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.

Try the attached link

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562191

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

On Mon, 17 Jul 2006 12:04:01 -0700,
wrote:

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.