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 vote287 views1 answer
Visual stuiod not recognising desgined labels
VBA
4 votes301 views2 answers
Excel vba last column with data
VBA
0 vote302 views1 answer
How to use if condition in time vba
VBA
0 vote289 views1 answer
Vlookup columns not next to each other
VBA
0 vote312 views1 answer
Find if year is leap year vb
VBA
0 vote291 views1 answer
Vbscript abs
VBA
0 vote295 views1 answer
How to get the value of optionbutton in vba
VBA
1 vote329 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote367 views1 answer
Excel vba delete columns in range
VBA
1 vote314 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA