Visual Basic for Applications Reference

  • Article

FreeFile Function

See Also    Example    Specifics

Returns an Integer representing the next file number available for use by the Open statement.

Syntax

FreeFile[(rangenumber)]

The optional rangenumber argument is a Variant****that specifies the range from which the next free file number is to be returned. Specify a 0 (default) to return a file number in the range 1 255, inclusive. Specify a 1 to return a file number in the range 256 511.

Remarks

Use FreeFile to supply a file number that is not already in use.