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 vote137 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote196 views1 answer
Selecttoken em vbnet e json
VBA
0 vote179 views1 answer
Excel vba address not absolute
VBA
0 vote188 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote186 views1 answer
WGET FTP
VBA
1 vote201 views1 answer
Extract the second word in a text in excel
VBA
0 vote191 views1 answer
Average vba
VBA
0 vote206 views1 answer
Delete all controls in an area vb
VBA
0 vote186 views1 answer
Excel vba cell on change
VBA
0 vote211 views1 answer
Build an index all files of a FTP site
VBA