Nested Do Loops

Hi Everyone,

I am after some help please!

I am trying to nest a do loop within a do loop so that I can generate multiple iterations. ie the second do loop executes for every loop of the first loop.

I want to do this because i am trying to write a macro that scans a file system for a folder with a time stamp in the file name (have to use the file name - cannot use date modified) and need to loop backwards through all the possible combinations of hours, days, months and years until the latest folder is found.

The code that I have written with help doesn’t display any results when I execute it.

When I comment out each do loop in turn so that there is only one loop executing the message "...is a valid folder/path." is displayed but the folder that the message specifies does not exist when I check

Please help!

Please Login or Register  to view this content.

Your solution is here.

Please note that when posting code on the forum you must use code tags. I have added them for you on this occasion as it's your first post, but please use them in future.