Ok I've foolishly decided to to list ALL my albums which have been converted to MP3 (for use in car) but would take weeks and weeks to type them all into a spreadsheet in excel

is there any way to transfer FOLDER NAMES into some sort of list? dont want to list each song on the album

any ideas much appreciated

I wish I knew. I just typed in about 3000 CD titles and it took me about six hours.

well ive got VB code which will do all the titles etc... just cant get it to just do the folder names

if anyone needs the code here it is:

Sub IndexFiles()
With Application.FileSearch
.LookIn = "C:\MyMusic"
.FileType = msoFileTypeAllFiles
.SearchSubFolders = True
.Execute
End With
cnt = Application.FileSearch.FoundFiles.Count
For i = 1 To cnt
Rng = "A" & i
Range(Rng).Value = Application.FileSearch.FoundFiles.Item(i)
Next i
End Sub

That will search C:\my music <------------- change this to ur location

If You're Using Windows:
C:\Whatever Folder All of Your Albums Are>dir /B

If You're Using Linux:
>ls -1