List all folders/files?

Hello All

I am new to this forum and have limited knowledge of VBA.

I need a macro that will list all folders and files within a specified directory on my computer, but in a particular way.

Ordinarily, windows lists files first and then folders. I need the Macro to list folders first then files. I also need the macro to create index numbers for each line and for the index numbers to be sequential (not independent for files and folders). Ideally this would be displayed in an excel sheet in 2 separate columns. Here is an illustration :

01. Folder A
01.01 Folder A.A
01.01.01 File A.A.A
01.01.02 File A.A.B
01.02 Folder A.B
01.03 File A.A
02. Folder B
03. Folder C
03.01 Folder C.A
03.02 File C.A
04. File A
05. File B


Any suggestions would be much appreciated.

Many thanks,

MacManzx

See Chip Pearson's site, here:

http://www.cpearson.com/Excel/foldertreeview.aspx

for a macro that will list all files and folders.

Hope this helps.

Pete