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

6 votes194 views1 answer
Excel vba get the path of current workbook
VBA
0 vote208 views1 answer
Excel vba paste all to each sheet in workbook
VBA
2 votes187 views1 answer
Date format for ms chart vb.net
VBA
1 vote184 views1 answer
Vbscript convert ascii code to character
VBA
1 vote206 views1 answer
Vba ubound array 2-dimensional
VBA
-1 vote200 views2 answers
Excel vba delete empty rows
VBA
0 vote205 views1 answer
Excel vba protect scenarios
VBA
0 vote144 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote206 views1 answer
Extract the second word in a text in excel
VBA
1 vote179 views1 answer
How to do error handling in access vba
VBA