You can do all that and much more with my DirTree add-in available for
free at http://www.cpearson.com/Excel/foldertree.aspx.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 20 Mar 2009 23:51:01 -0700, Pawan
wrote:

Hi.

I have following requirement:

I have a folder with several folders and files inside it. I want to write a
code whihc will generate a list of folders and / or files in this main
folder. Means I want to list all the folder/file names in one excel file. The
code should ask me two thing:
1. Do you want the list of folders only, files only or both?
2. Do you want to create Hyperlink for the list created?

This hyperlink should open the corresponing folder/file automatically.

Is this possible?

Thank you

Regards,
prm