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?
 

Forum statistics

Threads
1,085,542
Messages
5,384,327
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top