s = "C:\Myfolder\MySheet.xls"
dt = filedatetime(s)

--
Regards,
Tom Ogilvy


"Koveras" wrote:

How can I find the date modified of an external file in Excel with a
macro? I am trying to merge only worksheets from files that are not
already in the current worksheet. Any ideas how to do this? thanks in
advance!