Search code examples
windowsscriptingvbscript

How to read from a text file using VBScript?


I am looking to see a simple way to read from and write to a text file using VBScript.

I think this is an acceptable method for writing to a file.

 Dim f, 
 Dim fso

 Set fso = CreateObject("Scripting.FileSystemObject")
 Set f = fso.CreateTextFile("C:\test.txt", True, True)

 f.WriteLine("Data to Add to file.")
 f.Close

However, I would like to know how to read from a file in a similar fashion.


Solution

  • Use first the method OpenTextFile, and then...

    either read the file at once with the method ReadAll:

    Const ForReading = 1
    Dim file, content
    Dim fso
    
    Set fso = CreateObject("Scripting.FileSystemObject")
    Set file = fso.OpenTextFile("C:\test.txt", ForReading)
    content = file.ReadAll
    

    or line by line with the method ReadLine:

    Const ForReading = 1
    Dim dict, file, row, line
    
    Set dict = CreateObject("Scripting.Dictionary")
    Set fso = CreateObject("Scripting.FileSystemObject")
    Set file = fso.OpenTextFile ("c:\test.txt", ForReading)
    row = 0
    Do Until file.AtEndOfStream
      line = file.Readline
      dict.Add row, line
      row = row + 1
    Loop
    
    file.Close
    
    'Loop over it
    For Each line in dict.Items
      WScript.Echo line
    Next