Getting File Date,Time and Size 3

[CaKiwi]

Hi,

Can anyone tell me how to find the creation date, creation time and size of a file in VB?

Thanks CaKiwi

 

[MattSmithProg]

FileDateTime returns the date and time the file was last modified but not created. I am not sure if there is a VB command to tell you creation time/date. Maybe an API.

FileLen returns the file size in bytes.

Hope this helps.

Matt

 

[CaKiwi]

Thanks for the rapid response. Modified time will be good enough for my purpose. CaKiwi

 

[Dagon]

look up FileDateTime(), FileLen()

 

[JustinEzequiel]

in case anybody's interested...

Option Explicit

Private Sub Command1_Click()
  Dim oFSO As Object
  Dim oFile As Object
  Dim sFile As String
  
  sFile = "C:\My Documents\OT.xls"
  
  Set oFSO = CreateObject("Scripting.FileSystemObject")
  Set oFile = oFSO.GetFile(sFile)
  With oFile
    Debug.Print "DateCreated", .DateCreated
    Debug.Print "DateLastModified", .DateLastModified
    Debug.Print "Size", .Size
    Debug.Print "ShortPath", .ShortPath
  End With
  
  Set oFile = Nothing
  Set oFSO = Nothing
End Sub

gives
[tt]
DateCreated 7/9/01 5:35:35 PM
DateLastModified 1/12/02 1:19:18 PM
Size 152064
ShortPath C:\MYDOCU~1\OT.XLS[/tt]