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 vote154 views1 answer
Excel protect cells with formulas
VBA
0 vote163 views1 answer
Excel vba formatconditions positive
VBA
0 vote173 views1 answer
Excel vba protect worksheet without password
VBA
0 vote164 views1 answer
Vba border weight
VBA
1 vote165 views1 answer
Excel vba last column in range
VBA
0 vote168 views1 answer
Vbscript abs
VBA
18 votes351 views2 answers
Vba make word from bytes
VBA
1 vote165 views1 answer
Change the first item in a queue vb.net
VBA
1 vote175 views1 answer
Excel vba array remove first
VBA
0 vote164 views1 answer
Vba open report
VBA