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 vote325 views1 answer
Vba dictionary clear
VBA
2 votes321 views2 answers
Constructor vb.net
VBA
0 vote333 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
1 vote362 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
1 vote379 views1 answer
Vba login website
VBA
1 vote294 views1 answer
Ms access open form to new record
VBA
1 vote334 views1 answer
Excel vba compare 2 rows
VBA
0 vote341 views1 answer
Vbnet make a string to unicode converter
VBA
4 votes325 views1 answer
Excel vba check cell not empty
VBA
1 vote331 views1 answer
Add control vb
VBA