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
Printable View
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
Have a look there :
http://www.vbapi.com/ref/g/getfilein...nbyhandle.html
Code:'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")