Macro to generate list of folders

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate document folders for Excel list. 6
Macro to generate powerpoint slides 43
List ALL folders and files 2
Help needed - Strange hyperlink problem 5
Creating folders as per date. 4
How to get list of subfolders, including shortcuts to folders? 1
Generate list of number 5
Using VBScript to list all folders in a directory and files ... 1

Top