Macro to generate list of folders

  • Thread starter Thread starter Pawan
  • Start date Start date
P

Pawan

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
 
Back
Top