How do you find the size of a file

[RohanWest]

hi there i have a database file and i need to find the size of it, any idea how you do it?

Also any idea if you can access any other usefull properties of a file like when it was created, modified?

Rohan

[Gilles]

Have a look there :

http://www.vbapi.com/ref/g/getfilein...nbyhandle.html

[HeSaidJoe]

'file information using File Scripting Object (fso)
'date created...date last modified...date last accessed
'http:\\webhome.globalserve.net/enyaw

 Private Sub Form_Load()
 
 Dim sFile As String
 sFile = "c:\my documents\my file.txt"
 
 Dim fso As Object
 Set fso = CreateObject("Scripting.FileSystemObject")

 MsgBox "The file " & sFile & " was created on: " & fso.GetFile(sFile).DateCreated
 MsgBox "Last modification to file: " & fso.GetFile(sFile).DateLastModified
 MsgBox "Last date file was accessed: " & fso.GetFile(sFile).DateLastAccessed

 Unload Me

End Sub

msgbox Filelen(mypath\mydb.mdb")