View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default Getting a File Date & Time stamp

Hi:
From the vba online help:
'------------------------------
Sub ShowFileInfo()
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("E:\Computer\Archive\Graphics\VCRPause. bmp")
s = f.DateCreated
MsgBox s
End Sub
'-------------------------------

See online-help for the File Object.
Regards,
Sebastienm

"James" wrote:

Hi
Is it possible to get a file date & time stamp info (any particular file
stored on harddrive) from within VBA. How??

Thats a lot for your help

James