Creating an index in Excel from the windows directory structure for specific folders

[MikeF47]

Creating an index in Excel from the windows directory structure for specific folders and sub folders

I keep the picture archive for our Historical Society and would like to create an index in an Excel spreadsheet.

Is it possible to automate the indexing process by collecting the information directly from the window directory and populating the required fields?
I have attached an example of what I would like the finished article to look like
Can anyone help me please as I have no programming skills at all.

[Glenn Kennedy]

I'm not sur if I follow you. You can get the street/road and village easily enough; but where are the other items listed?

[Kyle123]

You could loop through a set of folders and populate the links to the directories, however the other information doesn't look like the sort of information that you could retrieve

[NeedForExcel]

Hi,

please see the file attached.

This will help you get all the Excel files paths from a Folder & its subFolders..

Once we have this, we can get the data from each file..

[MikeF47]

Sorry Dave but I could not download or open this file.

[NeedForExcel]

Not sure why that is the case. I can download it aswell as open it from my computer aswell as 1 more computer

[MikeF47]

Hi Glenn
Thanks for the answer. I have tried to download and open the file but it will not open.
The reference is the file name the other items I agree cannot be download.

[Glenn Kennedy]

Hi. I think, having seen some of the other contributions, that I've misread your request. But anyhow... in C4
=TRIM(MID(SUBSTITUTE("/"&$B4,"/",REPT(" ",125)),125*COLUMNS($A:F),125)) drag down.

In D4 =TRIM(MID(SUBSTITUTE("/"&$B4,"/",REPT(" ",125)),125*COLUMNS($A:E),125)) drag down