Open File With Latest Date

Hi all,

I am trying to write a macro to open a file within a folder. All the files in this folder have the same name, except the date at the end of them is different. There is no consistency to how often these reports are generated, so I need to just open the file with the latest date. I also cannot use the most recently opened / edited because we often have to look back at these files. Currently using this code and changing the date every day until I can figure this out lol:

Please Login or Register  to view this content.

thanks!

Originally Posted by JBeaucaire

So, you would want to take TODAY as a starting date, construct a path and filename based on today's date, and see if that file exists? If so, open it. If not, go back one day, repeat until you find the most recent existing file?

Yes, that would be perfect!

Thanks. How is your Cnt variable working in this?

Ok that makes sense. Took me a while to understand how VBA knew Cnt = 0 to start, but I guess it's implied?

This line:

Please Login or Register  to view this content.

I can tell it's being used to say if the report is found, stop looping. But not quite clear on how that works. I thought Len would result in the length of the string of the file path to sOpenLastReport. But now I'm thinking maybe zero is being used as a "False" value. If that's the case, I have no idea how length of a string would make any sense. Hope you can explain this final step!

Thanks!

Ooohhhhh I understand now. That's clever.

I like to understand the things people help me with in this forum in case they break. I ALWAYS mark as solved and add to reputation to those who have been helpful, which you have been. So thank you, and here is to your reputation!