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 vote366 views1 answer
Openfiledialog specific folder
VBA
0 vote382 views1 answer
Excel vba hide gridlines
VBA
0 vote330 views1 answer
How to self delete a vbscript file
VBA
0 vote360 views1 answer
Vba word open document read only
VBA
0 vote358 views1 answer
Select case vba
VBA
0 vote382 views4 answers
Jwt token vb.net validation
VBA
0 vote359 views1 answer
Vba verticalalignment
VBA
0 vote383 views1 answer
Excel vba ternary
VBA
0 vote362 views1 answer
Excel vba join variant array
VBA
3 votes380 views1 answer
Vba request json
VBA