VB Script to open multiple folders on HD & provide file property details.

Hello all...

I am creating a database spreadsheet for files I have on my hard drive. I found the script I want, and it works, but there are 2 functions I would like to have it do to smooth the process.

What this code does is pulls all the files in 1 folder & gives me the data from the "Properties/Details" tab of the file. I found the information I want it to provide & its working like a charm. However the issue is, I need it to open the folders within the folder I selected.

Example:
Files I want are in: G:/#
G:/A
G:/B
G:/C
G:/D
and so on until G:/Z

If I select G:/ it just provides the folder names and not any files within those folders. If I select G:/# I get the files I wanted in that folder, but it won't pull from the other folders. So ultimately, I THINK (I am a self teacher of excel & am FAR from a pro, so you all please help if there is an easier process) what I need to do is add a code that will automatically selected the G drive when I run the macro (right now it has a popup window asking for the folder location) and then the code will repeat over and over to automatically go through each folder running the script until there is no more folders to open.

I hope this made sense, I tried to be as detailed as possible but if someone would like to see my excel sheet I am working with, I won't mind sharing.

Code is:

Please Login or Register  to view this content.

Thanks for any help provided in advance BTW I am running 2010

Please read the forumrules about crossposting.

https://www.mrexcel.com/forum/excel-...y-details.html

Hello LauraShepherd-Boyd,

How do you want the properties for each file to be saved? One under the other on the same worksheet or each on a separate worksheet?

Do want only the files in the parent folder and it's first level of subfolders or all subfolders?

Hi Laura,

It might take an hour to give you a good answer with our free time. If you ask the question to multiple forums, multiple people will spend time working on this problem. I'm pretty slow in posting a good answer so you might not even need it by the time someone else gives you an answer. SO.. If you post the question in multiple forums, we are less likely to want to spend our time to help with an answer. Does that makes sense?

Hello LauraShepherd-Boyd,

Here is the updated macro. It will let you select the folder. All folders in the in the parent folder are then opened one by one. The files in each folder are then listed on the active worksheet with the details you provided.

Please Login or Register  to view this content.

Hello Laura,

You're welcome. I would be happy to answer your questions and teach you about the Shell.