Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I put the filesize of a file in a variable?
- Thread starter BaDi
- Start date
Use FSO (File System Object - reference to Microsoft Scripting), to get the file size, and set the return value to a variable.
Dim oFso As New Scripting.FileSystemObject
Dim f As Scripting.File
Set f = oFso.GetFile("C:\myFile"
Debug.Print f.Size
Dim oFso As New Scripting.FileSystemObject
Dim f As Scripting.File
Set f = oFso.GetFile("C:\myFile"
Debug.Print f.Size
JustinEzequiel
Programmer
alternative...
Code:
x = FileLen("C:\WINDOWS\win.com")- Status
