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 vote172 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote157 views1 answer
Find days in month vba
VBA
0 vote220 views2 answers
VB
VBA
6 votes163 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote158 views1 answer
Vbs exec hidden
VBA
0 vote183 views1 answer
Excel vba protect shapes
VBA
0 vote168 views1 answer
Vba loop through textboxes
VBA
22 votes317 views1 answer
Xl vba check for folder
VBA
5 votes189 views1 answer
Excel vba how to unit test vba code
VBA
0 vote149 views1 answer
Vba argument is set
VBA