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 vote182 views1 answer
Excel vba unlock sheet without password
VBA
22 votes295 views1 answer
Xl vba check for folder
VBA
0 vote200 views2 answers
Excel vba store array and write to sheet
VBA
0 vote158 views1 answer
Vba exit while
VBA
5 votes177 views1 answer
Excel vba last byte from INTEGER
VBA
1 vote164 views1 answer
Vba optional
VBA
0 vote147 views1 answer
Vba DisplayGridlines
VBA
0 vote164 views1 answer
Columns dont autoresize on program start vb.net
VBA
3 votes146 views1 answer
Excel vba read registry key value
VBA
3 votes151 views1 answer
Excel vba last row in range
VBA