Is there a way to automatically duplicate a system subfolder structure in Excel?

kelle

Board Regular
Joined
Apr 1, 2015
Messages
93
I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox.

The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who;

Inquiries
Oct 25 2019 - Mr. X - topic (so in this folder would be a copy of the initial Outlook request)
Oct 25 2019 - Mr. X - topic
Oct 25 2019 - Ms. Y - topic

To track responses, I'm wondering if there's any VBA way to get the spreadsheet file to automatically "populate" the first few rows with the details from these folders--ie, whenever the Excel spreadsheet is opened, it automatically looks for any new subfolders that have been added, and then pulls the metadata (or even just the title of the subfolder) into the first few rows, with Date, Request From, and topic.

Is there a way to do this?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top