File's last modified date

[Josh Sale]

Does anybody know how to verify if a file exists and if it does to retrieve
it's last modified date using XL97 VBA?

TIA,

josh

 

[Bob Phillips]

Josh,

This is the sort of thing you want

If Dir("c:\myTest\bob.xls") <> "" Then
MsgBox FileDateTime("c:\myTest\bob.xls")
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Josh Sale]

Thanks Bob!

Josh,

This is the sort of thing you want

If Dir("c:\myTest\bob.xls") <> "" Then
MsgBox FileDateTime("c:\myTest\bob.xls")
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)