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 vote302 views1 answer
Vba text to general
VBA
0 vote308 views1 answer
Excel vba show developer tab
VBA
18 votes456 views3 answers
Excel-vba make integer
VBA
0 vote319 views1 answer
For each item in folder outlook vba
VBA
0 vote328 views1 answer
Excel last used row
VBA
1 vote300 views1 answer
Excel vba close form escape key
VBA
0 vote297 views1 answer
Vba first line of string
VBA
0 vote326 views1 answer
Vbs exec hidden
VBA
3 votes336 views2 answers
Vba date to string
VBA
0 vote317 views1 answer
Excel vba cell on change
VBA