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 vote121 views1 answer
Excel vba range contains
VBA
5 votes134 views1 answer
Excel-vba get integer high byte
VBA
0 vote132 views1 answer
Test if form is open vb
VBA
0 vote132 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote120 views1 answer
Vb streamreader
VBA
0 vote125 views1 answer
How to add line graph vb net
VBA
0 vote122 views1 answer
Vbnet find highest value in chart
VBA
0 vote144 views1 answer
Excel vba convert cells address
VBA
0 vote137 views1 answer
Tester si une case est vide vba
VBA
6 votes123 views1 answer
Excel vba check if a string only contains alpha characters
VBA