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 vote213 views1 answer
Vba parameter adodb null value
VBA
0 vote240 views1 answer
Vba timestamp -- milliseconds
VBA
1 vote235 views1 answer
Set font for ms chart vb.net
VBA
0 vote213 views1 answer
Select case vba
VBA
0 vote224 views1 answer
Sort dictionary by key vba
VBA
0 vote261 views1 answer
Vba userform textbox wrap text
VBA
0 vote243 views1 answer
Excel R1C1 mode
VBA
-1 vote217 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote225 views1 answer
Vba min
VBA
5 votes243 views1 answer
Excel vba tool to help with refactoring code
VBA