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 vote223 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote218 views1 answer
How to put a gridpain in a vbox
VBA
3 votes251 views1 answer
Vba post request json
VBA
0 vote208 views1 answer
Vba sheet visible
VBA
1 vote210 views1 answer
Vba delete file
VBA
0 vote196 views1 answer
Vba argument is set
VBA
1 vote218 views1 answer
Extract the second word in a text in excel
VBA
2 votes192 views1 answer
Excel vba extract file name
VBA
1 vote208 views1 answer
Excel vba make cell visible
VBA
1 vote216 views2 answers
Get all column names from excel vba
VBA