Visual Basic for Applications Reference

Visual Studio 6.0

AvailableSpace Property

See Also    Example    Applies To    Specifics


Returns the amount of space available to a user on the specified drive or network share.



The object is always a Drive object.


The value returned by the AvailableSpace property is typically the same as that returned by the FreeSpace property. Differences may occur between the two values for computer systems that support quotas.

The following code illustrates the use of the AvailableSpace property:

Sub ShowAvailableSpace(drvPath)
    Dim fs, d, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set d = fs.GetDrive(fs.GetDriveName(drvPath))
    s = "Drive " & UCase(drvPath) & " - " 
    s = s & d.VolumeName  & vbCrLf
    s = s & "Available Space: " & FormatNumber(d.AvailableSpace/1024, 0) 
    s = s & " Kbytes"
    MsgBox s
End Sub