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 vote259 views1 answer
Excel vba urlmon
VBA
0 vote257 views4 answers
Jwt token vb.net validation
VBA
0 vote252 views1 answer
Vba remove last vbcrlf
VBA
3 votes224 views1 answer
Excel vba last row in range
VBA
0 vote250 views1 answer
Vba add shape oval
VBA
0 vote243 views1 answer
Not allow form to be resized
VBA
0 vote258 views1 answer
Vba parameter adodb null value
VBA
0 vote229 views1 answer
Excel vba assign shortcut key to button
VBA
1 vote258 views1 answer
How to put a gridpain in a vbox
VBA
0 vote238 views1 answer
Vb net check if file exists
VBA