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 vote991 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote138 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote131 views1 answer
Excel vba center userform
VBA
0 vote139 views1 answer
Vba sort the data Z to A
VBA
0 vote128 views1 answer
Vba test optional argument
VBA
0 vote139 views1 answer
Change form background image vb
VBA
0 vote128 views1 answer
Vba add shape oval
VBA
0 vote153 views1 answer
Vba multiple optional arguments
VBA
0 vote140 views1 answer
Vba word open document read only
VBA
0 vote134 views1 answer
Vba find sub dictionary
VBA