Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Write# Statement

Writes data to a sequential text file with delimiting characters.

Use Print# statement to print data to a sequential text file. Use Put# statement to write data to a binary or a random file.

Syntax:

Write Statement diagram


Write [#fileNum] {,|;} expression [, …]

Parameters:

fileNum: Any numeric expression that contains the file number that was set by the Open statement for the respective file.

expression list: Variables or expressions that you want to enter in a file, separated by commas.

If the expression list is omitted, the Write statement appends an empty line to the file.

To add an expression list to a new or an existing file, the file must be opened in the Output or Append mode.

Strings that you write are enclosed by quotation marks and separated by commas. You do not need to enter these delimiters in the expression list.

Each Write statement outputs a line end symbol as last entry.

Numbers with decimal delimiters are converted according to the locale settings.

Example:

  Sub ExampleWrite      Dim iCount As Integer      Dim sValue As String      iCount = Freefile      Open "C:\Users\ThisUser\data.txt" For Output As iCount      sValue = "Hamburg"      Write #iCount,sValue,200      sValue = "New York"      Write #iCount,sValue,300      sValue = "Miami"      Write #iCount,sValue,450      Close #iCount  End Sub  
  Sub ExampleWrite      Dim iCount As Integer      Dim sValue As String      iCount = Freefile      Open "~/data.txt" For Output As iCount      sValue = "Hamburg"      Write #iCount,sValue,200      sValue = "New York"      Write #iCount,sValue,300      sValue = "Miami"      Write #iCount,sValue,450      Close #iCount  End Sub