Thread: how to retrieve properties of a file in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default how to retrieve properties of a file in VBA
MyStamp = FileDateTime("TESTFILE.xls") ' Returns "2/12/93 4:35:47 PM".


--
Regards,
Tom Ogilvy


"lvcha.gouqizi" wrote in message
oups.com...
I need to get the last modified time of some files (which I have
access) with URI like "H:\path\filename". The script is located at a
different disk like "D:\myscript". Is there anyway to do that? Thanks.



Reply With QuoteReply With Quote