Macro to Label folders with Tags and Filter as Required

Hello everyone,

I am relatively new to macro coding, but I shall explain none the less... Basically I have a large database of folders of examples of projects/notes etc, each with essentially lots of potential topic "tags". I want to sort them to be able to tell the macro what topic I am looking for and it give me the folders that contain that info. I will need to tag each folder individually (which is no problem). I am looking for a piece of script (that either exists or that I can write) that will do the following:

- tag specific folders with numerous "tags". The folders will all be stored in a database. The tags will be user input.
- sort these folders based on specified tags and show filepath/location/name/file number or something unique based on the tags input

I am not sure if this is possible, or if someone has a clever idea of how to approach this problem, but any help is much appreciated! Any questions please ask.

Cheers,

Cheers Leith,

Ok an example would be...I have many many folders with examples of projects I have completed in the past with notes on numerous aspects of the project (it's bridge engineering). So I wish to create tags like:

- single span bridge
- concrete
- I-girder
- short/medium/long-span bridge
- XXX Department of Transportation
- XXX Specifications
- XXX Design Codes
...

The list of tags is endless. The idea is when I want to look for an "I-girder" example I can search based on that. Or based on "concrete", or on any other tag for that matter. As it stands I have to sort the folders into sub folders and only get to name each folder once. Eg the "I-girder" example is in the "concrete" folder which is in the "single span bridge" folder, and there is no way of me displaying all of the "I-girder" bridge examples, only all the "single span bridge" examples as I only have that particular folder.

Does this explain a little better? I have been told I need to write a Wiki (which would be great), but I think a macro could work...

The folders are all in the same parent folder (this is the database of folders I currently have).

The tags are not part of the folder name and I need to be able to add tags to new folders relatively easily as I add to my database.

Thanks,

Ok thanks Leith!

Hi Leith,

Cheers for you help with this, did you make any headway with the macro, or any info on it?

Thanks,

Excel_2014

It's not ideal, but that could be an alternative - just to have the tags input in a excel file and when I have new files I just update the tags for that file. Would it then be easy enough to link new folders to the macro and along with some new tags?

Essentially I'm looking to write a program to do this for me so it's difficult to put together an example! Can I explain the following example better in any way?

"Ok an example would be...I have many many folders with examples of projects I have completed in the past with notes on numerous aspects of the project (it's bridge engineering). So I wish to create tags like:

- single span bridge
- concrete
- I-girder
- short/medium/long-span bridge
- XXX Department of Transportation
- XXX Specifications
- XXX Design Codes
...

The list of tags is endless. The idea is when I want to look for an "I-girder" example I can search based on that. Or based on "concrete", or on any other tag for that matter. As it stands I have to sort the folders into sub folders and only get to name each folder once. Eg the "I-girder" example is in the "concrete" folder which is in the "single span bridge" folder, and there is no way of me displaying all of the "I-girder" bridge examples, only all the "single span bridge" examples as I only have that particular folder."

Thanks,

No need to open the folders, just identify them. But the user could specify more than one tag, to elaborate on the previous example, if I want a concrete, I-girder, single span bridge, I search for those tags and I would get results containing those tags. This way I could have thousands of examples and notes etc and each folder has a tag with what it contains. Then when I am looking for a specific example, I can input the tags and get all of the examples in the data base that match the search. Presently I do this by folder structure, but it allows me only to specify one folder name...this is equivalent to one tag, which is limiting.

Thanks,

That would be ideal. Thanks.

Hi Leith,

Did you manage to put together the above?

Cheers,