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 vote215 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote223 views1 answer
Vba variable number of arguments
VBA
0 vote232 views1 answer
For each item in folder outlook vba
VBA
0 vote220 views4 answers
Vgrive,deb
VBA
25 votes495 views2 answers
Excel vba folder exist
VBA
2 votes206 views1 answer
Excel vba check if key is in collection
VBA
2 votes202 views1 answer
Vba split string
VBA
8 votes346 views1 answer
Excel vba determine number of elements in a 1D array
VBA
-1 vote230 views1 answer
Vba sendkeys
VBA
0 vote209 views1 answer
Vba get application version
VBA