macros to list all files in folder THEN get info from files?

Hi all,

New to this forum, been banging my head against the wall on this one, thought I would turn to the pros!

I would like to create a macro that would get a list of all the files in a folder, and if possible have the option of also searching in subfolders at the same time.

I would like it to return file name, file path, date modified, file size, file extension as well, in separate columns.

Here is the SUPER tricky part that would make this the cat's meow.

After populating the list:

For all files -> make file path a hyperlink.

For html files -> create a new column that would have the information found between the html title tags?

Big thanks!

That is straight up perfect. works very well

How would I make a cell the target folder path? Is it also possible to have a toggle switch for whether or not to list files in subfolders?

This helps a lot. I have added it into the macro I need to work, but I have one more question. I have to process the links to point to our external site, no local server. I can clean up the cell value, but how to I update the hyperlink path to it?

Here is my macro

Please Login or Register  to view this content.

Thanks!