Vba get text file content

' Returns an array of lines from a text file
Function FileInArray() As Variant
    Dim fileSO As Object, textFile As Object, content
    On Error GoTo CExit
    Set fileSO = CreateObject("Scripting.FileSystemObject")
    Set textFile = fileSO.OpenTextFile("C:\temp\file.txt", 1)
    content = textFile.ReadAll
    FileInArray = Split(content, vbNewLine)
    textFile.Close
CExit:
End Function

Similar codes

0 vote189 views1 answer
Style percent not found vba
VBA
1 vote219 views1 answer
Extract the second word in a text in excel
VBA
6 votes212 views1 answer
Excel vba get the path of current workbook
VBA
0 vote229 views1 answer
.net crash app
VBA
0 vote202 views1 answer
Excel vba disable mouse click
VBA
-1 vote194 views1 answer
For i in range vba
VBA
13 votes477 views2 answers
Vba write text file
VBA
0 vote190 views1 answer
Excel vba disable screen update
VBA
1 vote211 views1 answer
Excel vba array remove first
VBA
1 vote213 views1 answer
Excel vba last row of range
VBA