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 vote282 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote264 views1 answer
Vba DisplayGridlines
VBA
0 vote288 views1 answer
Vbs exec hidden
VBA
0 vote281 views1 answer
Vba remove last vbcrlf
VBA
0 vote279 views1 answer
Excel vba join variant array
VBA
1 vote262 views1 answer
Excel vba first and last row and column in range
VBA
0 vote278 views1 answer
For each item in folder outlook vba
VBA
3 votes263 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote272 views1 answer
Excel run macro every 5 minutes
VBA
5 votes328 views1 answer
Excel vba last byte from INTEGER
VBA