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

1 vote198 views1 answer
Vba delete file
VBA
0 vote203 views1 answer
Excel vba ternary
VBA
0 vote270 views1 answer
Amd64 vs arm64 linux
VBA
8 votes263 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote204 views1 answer
Send text to clipboard vb.net
VBA
0 vote185 views1 answer
Excel vba current folder
VBA
1 vote222 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote217 views1 answer
Weekday vba
VBA
0 vote198 views1 answer
Vba timestamp -- milliseconds
VBA
7 votes201 views1 answer
Excerl vba array to range
VBA