LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 177
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Date Modified snickers22 Excel Worksheet Functions 2 June 16th 09 06:11 PM
Modified Date D Excel Discussion (Misc queries) 12 February 12th 07 01:39 PM
Date Last Modified Emma Hope Excel Worksheet Functions 3 July 19th 06 09:06 PM
date modified flow23 Excel Discussion (Misc queries) 1 November 24th 05 12:25 PM
modified date Monty New Users to Excel 1 June 6th 05 12:50 PM


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"