Reading a text file is something a computer programmer must know how to do when developing computer programs. In VBA you can use the "Input #" statement to open a text file and read its contents. The data read from the file is stored in memory for you to manipulate as you wish. Using VBA to read a text file is useful when you need to transfer large amounts of data to an Excel spreadsheet.
- Skill level:
- Moderately Easy
Click the "Developer" tab, click "Visual Basic" and click the "Insert" menu. Select "Module" to insert a new code module.
Start by creating a sub-procedure using the following code:
Private Sub readTextFile()
Create three variables you will use to read the text file:
Dim file Text As String
Dim myTextFile As String
Dim memFile As Integer
Define the path and file name of the text file you want to read:
myTextFile = "F:\temp.txt"
memFile = FreeFile
Open the file, read its contents and close the file:
Open myTextFile For Input As #memFile
file Text = Input$(LOF(1), 1)
Display the text file results through the Immediate window.
End the sub-procedure by typing "End Sub" (without quotes). Press F5 to run the procedure and read the file.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for