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

1 vote197 views1 answer
Vba loop through files in folder
VBA
0 vote183 views1 answer
Arq linux
VBA
0 vote178 views1 answer
Vb.net change cursor to wait
VBA
8 votes210 views1 answer
Excel vba determine number of elements in a 2D array
VBA
5 votes189 views1 answer
Excel vba left word from Long Integer
VBA
1 vote186 views1 answer
Add a index column power bi
VBA
0 vote180 views1 answer
Excel vba scroll to cell
VBA
18 votes259 views3 answers
Excel-vba make integer
VBA
1 vote189 views1 answer
VBA Loop through recordset
VBA
0 vote203 views1 answer
Vba boolean to string
VBA