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 vote192 views1 answer
Excel vba formatconditions positive
VBA
0 vote123 views1 answer
How to sort datagridview in vb.net
VBA
2 votes170 views1 answer
Date format for ms chart vb.net
VBA
0 vote174 views1 answer
Vba find last column in a row with data
VBA
2 votes169 views1 answer
Vba split string
VBA
2 votes174 views2 answers
Excel vba copy values range to another range
VBA
22 votes346 views1 answer
Excel vba check if directory exists
VBA
0 vote170 views1 answer
Vba change named range address
VBA
0 vote179 views1 answer
Nested if else in vb.net
VBA
0 vote189 views1 answer
Vba table header name
VBA