I have a series of files that are saved with just the date and time in the same folder. Is it possible to have a macro look in the folder and open the most recent file?
So for example. Look in:
M:\My Folder\\Template REPORTS
See the following files:
1-22 0833.xlsx
1-22 0845.xlsx
1-22 0901.xlsx
and then open:
1-22 0901.xlsx
Hello Jiptastic,
This should work for you.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
With a little tweaking, this worked great. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks