View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
 
Posts: 37
Default Using FoundFiles to list by path and filename

I am using a macro that lists files that are in the directory I choose
via browseforfolder. The founfiles function lists files
alphabetically, regardless of which subfoler it is in. Is there a way
to get a list of files in a folder to appear alphabetically, and then
continue the list with files in the first subfolder and so on?

for example, if i have a folder called 'pictures' that has sub folders
'home' and 'vacation' I would want all the files in 'pictures' to be
listed, then the files in 'home', then the files in 'vacation'. Thanks
for any help/advice you can give.