Difference between WRITE & PRINT Function in VBA

Write #:

1. Writes data to a sequential file.

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

3. 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.

Print # : 

1. Writes display-formatted data to a sequential file.

2. Data written with Print # is usually read from a file with Line Input # or Input.

3. All data written to the file using Print # is internationally aware; that is, the data is properly formatted using the appropriate decimal separator.

Because Print # writes an image of the data to the file, you must delimit the data so it prints correctly. If you use Tab with no arguments to move the print position to the next print zone, Print # also writes the spaces between print fields to the file.