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 vote291 views1 answer
Vba first cell in range
VBA
0 vote228 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote289 views1 answer
What does vbs stand for
VBA
0 vote283 views2 answers
Excel vba protect cells with formula
VBA
1 vote274 views1 answer
Close form vba
VBA
0 vote271 views1 answer
Docker vboxmanage not found
VBA
0 vote301 views1 answer
How to format a textbox as date vb net
VBA
0 vote279 views1 answer
Change "location" of binding navigator vb
VBA
0 vote308 views1 answer
Excel vba Column Name from Column Number
VBA
3 votes316 views1 answer
Extract word in a text in excel
VBA