How Write# works in VBA

Writes data to a sequential file.

Syntax

Write #filenumber, [outputlist]

The Write # statement syntax has these parts:

Part	Description
filenumber	Required. Any valid file number.
outputlist	Optional. One or more comma-delimited numeric expressions or string expressions to write to a file.

Remarks

1. Data written with Write # is usually read from a file with Input #.

2. If you omit outputlist and include a comma after filenumber, a blank line is printed to the file. Multiple expressions can be separated with a space, a semicolon, or a comma. A space has the same effect as a semicolon.

3. When Write # is used to write data to a file, several universal assumptions are followed so the data can always be read and correctly interpreted using Input #, regardless of locale:

   

• Numeric data is always written using the period as the decimal separator.

• For Boolean data, either

#TRUE# Or #False# is printed

• Date data is written to the file using the universal date format. When either the date or the time component is missing or zero, only the part provided gets written to the file.

• Nothing is written to the file if outputlist data is Empty. However, for Null data,

#NULL# is written

• If outputlist data is Null data,

#NULL# is written to the file.

• For Error data, the output appears as

#ERROR errorcode#

4. The Write # statement inserts commas between items and quotation marks around strings as they are written to the file. You don't have to put explicit delimiters in the list. Write # inserts a newline character, that is, a carriage return–linefeed (Chr(13) + Chr(10)), after it has written the final character in outputlist to the file.

Note:

You should not write strings that contain embedded quotation marks, for example,

"1,2""X"

As Input # parses this string as two complete and separate strings.

Read More