File's last modified date
 

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

File's last modified date
 

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" <jsale@tril dot cod wrote in message
...
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

File's last modified date
 

Thanks Bob!


"Bob Phillips" wrote in message
...
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" <jsale@tril dot cod wrote in message
...
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