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 vote295 views1 answer
Excel vba copy range with filter
VBA
0 vote283 views1 answer
Vba simple quote
VBA
8 votes377 views1 answer
Excel vba make word
VBA
0 vote296 views1 answer
Remove last 8 characters from string vb
VBA
1 vote279 views1 answer
Vba refresh pivot table
VBA
3 votes270 views1 answer
Vba request json
VBA
0 vote285 views1 answer
Vba table header name
VBA
4 votes292 views2 answers
Vba last row
VBA
0 vote300 views2 answers
Checking and changing system volume vb.net
VBA
0 vote259 views1 answer
Excel vba existence of a file
VBA