J Josh Sale Jan 12, 2004 #1 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
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
B Bob Phillips Jan 12, 2004 #2 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, 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)
J Josh Sale Jan 12, 2004 #3 Thanks Bob! Bob Phillips said: 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) Click to expand...
Thanks Bob! Bob Phillips said: 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) Click to expand...
