Hi Friends,
Need your kind help. Quite often I save reports in a folder that corresponds with today's date. Every time when I need to save a new report my macro creates a folder "YYYY-MM-DD" in the corresponding Quarter and Year folders (let's say C:\YYYY\Q#\YYYY-MM-DD). Now I want to write another piece of code (in addition to existing macro) which will make some comparison of today's and last saved reports. The problem is that I don't save reports every day and sometimes there could be 2-3 days gap in between. Could you please advise the way how I can find and open the last saved report? For simplicity let's assume that the name of report is always the same. All I need is to find the last created folder and to open the last saved report.
Tried to use DateAdd function with the negative second argument, but failed since have no idea how to loop it... Please help
Thanks in advance!
Bookmarks