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 vote337 views1 answer
Vba reverse string
VBA
1 vote336 views1 answer
Vba delete file
VBA
0 vote391 views1 answer
How to call gcd in vba
VBA
3 votes363 views1 answer
Excel vba make long from two shorts
VBA
9 votes477 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
8 votes499 views1 answer
Excel vba make word from bytes
VBA
2 votes338 views2 answers
Excel vba copy values range to another range
VBA
0 vote350 views1 answer
Excel vba disable screen update
VBA
5 votes352 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
1 vote334 views1 answer
VBA Loop through recordset
VBA