Open last modified file|VBA & Macros|Excel Forum|My Online Training Hub

If you want to open last modified file in the folder, try below code

Sub openLastModified()
Dim FolderPath As String, tableName As String, latestTblName As String
Dim latestModified As Date, modifiedDate As Date

FolderPath = "path to your folder"

tableName = Dir(FolderPath & "*.xlsx")

'or use below line for any type of file

'tableName = Dir(FolderPath & "*")

Do While tableName <> vbNullString
modifiedDate = FileDateTime(FolderPath & tableName)
If latestModified < modifiedDate Then
latestModified = modifiedDate
latestTblName = tableName
End If
tableName = Dir()
Loop

Workbooks.Open FolderPath & latestTblName