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

4 votes171 views2 answers
Vba last row
VBA
1 vote163 views1 answer
Ms access open form to new record
VBA
0 vote276 views1 answer
Visual basic cmd
VBA
0 vote237 views1 answer
Weekday vba
VBA
0 vote216 views1 answer
Excel vba join variant array
VBA
0 vote228 views1 answer
Change form background image vb
VBA
1 vote233 views1 answer
Vba login website
VBA
1 vote231 views1 answer
Excel vba to lower case
VBA
1 vote232 views1 answer
Excel vba last row of range
VBA
-1 vote239 views1 answer
Code for reading letters only in vb 6
VBA