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

5 votes402 views1 answer
Xlvba double quotes in string literal
VBA
1 vote364 views1 answer
Vba format string as cash
VBA
3 votes383 views2 answers
Vba active workbook path
VBA
6 votes386 views1 answer
Excel vba check if a string only contains letters
VBA
5 votes382 views1 answer
Vba low word from Long Integer
VBA
0 vote347 views1 answer
Limit combobox to list vba
VBA
1 vote341 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote350 views1 answer
Dynamic array vba
VBA
2 votes373 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote358 views1 answer
Search combobox items vb.net
VBA