Open most recently CREATED file in a folder

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

   Dim MyPath As String
    Dim MyFile As String
    Dim LatestFile As String
    Dim LatestDate As Date
    Dim LMD As Date
    MyPath = "\CustView"
    If Right(MyPath, 1) <> "\" Then MyPath = MyPath & "\"
    MyFile = Dir(MyPath & "*.xlsx", vbNormal)
    If Len(MyFile) = 0 Then
        MsgBox "No files were found...", vbExclamation
        Exit Sub
    End If
    Do While Len(MyFile) > 0
        LMD = FileDateTime(MyPath & MyFile)
        If LMD > LatestDate Then
            LatestFile = MyFile
            LatestDate = LMD
        End If
        MyFile = Dir
    Loop
    Workbooks.Open MyPath & LatestFile
    Range("A1").Select

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.)

Ok. Please add this UDF :

Function GetFileDateLastModified(strFile)
  GetFileDateLastModified = CreateObject("Scripting.FileSystemObject").GetFile(strFile).DateLastModified
End Function
Function GetFileDateCreated(strFile)
  GetFileDateCreated = CreateObject("Scripting.FileSystemObject").GetFile(strFile).DateCreated
End Function

And then change this line into :

'LMD = FileDateTime(MyPath & MyFile)
LMD = GetFileDateCreated(MyPath & MyFile)

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.

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.

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

Regards