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 vote203 views1 answer
Vb.net get name by Cell Click
VBA
2 votes129 views2 answers
Vba exit loop
VBA
0 vote121 views1 answer
Vba select file in folder
VBA
0 vote190 views1 answer
Vba line feed
VBA
-1 vote195 views1 answer
Code for reading letters only in vb 6
VBA
0 vote179 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote166 views1 answer
Excel VBA web scraping
VBA
0 vote157 views1 answer
Vbnet add new ecel sheet
VBA
1 vote170 views1 answer
Excel vba last column in range
VBA
0 vote181 views1 answer
Excel vba copy range with filter
VBA