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 vote236 views10 answers
Vba excel create event log
VBA
1 vote327 views1 answer
How to remove zeros in excel
VBA
1 vote314 views1 answer
VBA Loop through recordset
VBA
0 vote319 views1 answer
Vba min
VBA
1 vote335 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote316 views1 answer
Vba sheet hide unhide
VBA
0 vote309 views1 answer
Vbscript Trim
VBA
0 vote310 views1 answer
.net dark title bar
VBA
0 vote326 views1 answer
Group controls programmatically vb
VBA
3 votes311 views1 answer
Vba not equal
VBA