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

8 votes382 views1 answer
Vba make integer
VBA
1 vote344 views2 answers
Get all column names from excel vba
VBA
0 vote353 views1 answer
Vba random number
VBA
1 vote321 views1 answer
Vba compile error object required
VBA
0 vote318 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote346 views1 answer
Excel vba first working day month
VBA
0 vote349 views1 answer
Vba clear collection
VBA
0 vote329 views1 answer
Do while not vb.net
VBA
1 vote364 views1 answer
Random number generator vb.net
VBA
-1 vote303 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA