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 vote309 views1 answer
How to format a textbox as date vb net
VBA
5 votes334 views1 answer
Excel vba left word from Long Integer
VBA
0 vote245 views1 answer
Vba set vs dim
VBA
0 vote294 views1 answer
Vba add shape oval
VBA
0 vote278 views1 answer
Excel vba extract year
VBA
0 vote305 views1 answer
Date as number vb
VBA
0 vote296 views1 answer
Enable macros on opening workbook vba
VBA
0 vote375 views1 answer
Wpf dark title bar
VBA
0 vote300 views1 answer
Excel vba first working day month
VBA
0 vote282 views1 answer
Check range is in another range vba
VBA