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 vote231 views1 answer
Prive sub enter clicked vb
VBA
1 vote176 views1 answer
Vba exit do while
VBA
0 vote215 views1 answer
Excel vba formatconditions range
VBA
3 votes227 views1 answer
Vba http request json
VBA
0 vote228 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
5 votes572 views1 answer
Vlookup vba
VBA
0 vote310 views1 answer
Vba change active sheet
VBA
0 vote221 views1 answer
Vbnet line graph smooth lines
VBA
5 votes226 views1 answer
Excel vba low byte from INTEGER
VBA
2 votes208 views1 answer
Excel vba extract file name
VBA