Open most recently CREATED file in a folder

[go3go3go]

The following macro opens the most recently modified file in a folder. How can I get it to open the most recently created file?

Please Login or Register  to view this content.

[karedog]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[go3go3go]

Sorry about that.

[karedog]

Ok. Please add this UDF :

Please Login or Register  to view this content.

And then change this line into :

Please Login or Register  to view this content.

As a note, there could be unexpected desired on how Windows treat the file creation and modification date.
Lets say a file "ABC.TXT" is created on 1 Jan 2021, and it has modified several times and the last modification date is 15 Jan 2021.
Now, as long as the file stay in the folder it is placed, then it will be working as expected -> the modification date will always bigger than creation date
But if this file "ABC.TXT" is copied to another folder, then for this copied file, the modification date will be the same but the creation date will be set as the current time the file being copied, so for this copied file, the creation date will be bigger than modification date.
The macro above just get the creation date reported by Operating System (you can check this by examining the file from Windows Explorer). Should this not what you expected, you need to change the code to fulfill your expectation.

[go3go3go]

Ok. Please add this UDF :

Please Login or Register  to view this content.

And then change this line into :

Please Login or Register  to view this content.

As a note, there could be unexpected desired on how Windows treat the file creation and modification date.
Lets say a file "ABC.TXT" is created on 1 Jan 2021, and it has modified several times and the last modification date is 15 Jan 2021.
Now, as long as the file stay in the folder it is placed, then it will be working as expected -> the modification date will always bigger than creation date
But if this file "ABC.TXT" is copied to another folder, then for this copied file, the modification date will be the same but the creation date will be set as the current time the file being copied, so for this copied file, the creation date will be bigger than modification date.
The macro above just get the creation date reported by Operating System (you can check this by examining the file from Windows Explorer). Should this not what you expected, you need to change the code to fulfill your expectation.

Looks like that did it. Thank you very much!!!!!!!!!!!!!!

[AliGW]

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[karedog]

You are welcome, thanks for marking the thread as solved.

Regards