Note that I am indicating the file's path be provided along with its name...

If FileDateTime("c:\FilesPath\ABC.xls") Date + TimeSerial(10, 0, 0) Then
' The file's last modified date is later than 10am today
End If

The FileDateTime function is a built-in function in VBA which returns the
last modified date for the PathFileName passed into it as an argument.

Rick


"Eric" wrote in message
...
Does anyone have any suggestions on how to perform following tasks in
macro?
I would like to check the last updated for the file ABC.xls, if the last
updated is today after 10am, then perform macro, else skip running the
rest
of coding.
Does anyone have any suggestions?
Thank you in advance for any suggestions
Eric