Line Input# Statement

Reads a line from a sequential file into a variable.

Syntax:

Line Input Statement diagram


Line Input #fileNum, variable

Parameters:

fileNum: Number of the file that contains the data that you want to read. The file must have been opened in advance with the Open statement using the key word INPUT.

variable: The name of the variable that stores the result.

Line Input# ステートメントは、オープン済みのファイルから文字列を読み取って、その値を変数に格納します。文字列は、次に来るキャリッジリターン (ASC=13) かラインフィード (ASC=10) までのデータが、1 行ごとに読み取られます。行末の記号は読み取られません。

Example:


Sub ExampleWorkWithAFile
Dim iNumber As Integer
Dim sLine As String
Dim aFile As String
Dim sMsg As String
    aFile = "c:\data.txt"
    iNumber = Freefile
    Open aFile For Output As #iNumber
    Print #iNumber, "This is a line of text"
    Print #iNumber, "This is another line of text"
    Close #iNumber
    iNumber = Freefile
    Open aFile For Input As iNumber
    While Not eof(iNumber)
        Line Input #iNumber, sLine
        If sLine <>"" Then
            sMsg = sMsg & sLine & chr(13)
        End If
    Wend
    Close #iNumber
    MsgBox sMsg
End Sub