You may want to look at John Walkenbach's version:
http://www.j-walk.com/ss/excel/tips/tip103.htm
Russ wrote:
I use a spreadsheet with macros that lists all the file names of my songs
from my music folder into an excel spreadsheet ( I can post ir if it will
help). My new comupter has Office 2007 and the macro will not work. I do not
know macros well enough to fix it. Does anyone know of a spreadsheet I can
dowmload that would look into a folder and copy the file names into an execl
spreadsheet?
Thanks you for your help,
Russ
--
Dave Peterson