RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hello all,
We have a folder for a customer with reporting folders inside, so typically each customer folder will look like this:
What I want to do is to get the latest dated folder that has the YYYY-MM format, ignoring all other files and folders.
So once that is found, it can be added to a string to open that particular folder like:
I'd then want to open any xls file that had the name "Usage" in it.
Thanks guys!
We have a folder for a customer with reporting folders inside, so typically each customer folder will look like this:
Excel Formula:
2020-12
2021-01
2021-02
2021-03
2021-04
etc
2021-07
2021-08
[other folders]
[other files]
What I want to do is to get the latest dated folder that has the YYYY-MM format, ignoring all other files and folders.
So once that is found, it can be added to a string to open that particular folder like:
Company\Customers\Donk\2021-08\
I'd then want to open any xls file that had the name "Usage" in it.
Thanks guys!