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

6 votes159 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote162 views1 answer
Vba html document reference
VBA
0 vote160 views1 answer
Vba run command
VBA
0 vote144 views1 answer
Vba argument is set
VBA
0 vote171 views2 answers
Excel vba protect cells with formula
VBA
0 vote154 views1 answer
Excel vba address not absolute
VBA
3 votes211 views2 answers
Excel "vba" match last value
VBA
22 votes293 views1 answer
Xlvba check for folder
VBA
1 vote161 views1 answer
Excel vba get column name from number
VBA
3 votes173 views1 answer
Excel vba get the workbook full filename with path
VBA