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 vote172 views1 answer
Excel vba saveas force overwrite
VBA
0 vote203 views4 answers
Vgrive,deb
VBA
0 vote199 views1 answer
Visual basic cmd
VBA
-1 vote162 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote128 views1 answer
How to self delete a vbscript file
VBA
0 vote187 views1 answer
Sort dictionary by key vba
VBA
0 vote176 views1 answer
Change "location" of binding navigator vb
VBA
0 vote159 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote167 views1 answer
Putting marquee in vb.net
VBA
0 vote178 views1 answer
Excel vba select multiple shapes
VBA