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 vote232 views1 answer
Nested if else in vb.net
VBA
0 vote230 views1 answer
Vba get workbook name
VBA
0 vote250 views1 answer
Return na vba
VBA
0 vote218 views1 answer
Add items to combobox vb.net
VBA
1 vote230 views1 answer
Add control vb
VBA
0 vote240 views1 answer
VB Error Code BC30201
VBA
0 vote235 views1 answer
Excel vba automatic calculation
VBA
0 vote224 views1 answer
Vba run command
VBA
0 vote237 views1 answer
Vba count all row
VBA
3 votes247 views1 answer
Vba continue for each loop
VBA