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 vote112 views1 answer
Vba argument is set
VBA
5 votes143 views1 answer
Excel-vba get integer high byte
VBA
0 vote124 views1 answer
Enable macros on opening workbook vba
VBA
0 vote128 views1 answer
Vbs write file
VBA
0 vote137 views1 answer
Vbs run with cscript
VBA
0 vote113 views1 answer
Remove frist letter from string vbnet
VBA
0 vote123 views2 answers
Get excel file from email attachment in vba
VBA
1 vote128 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote122 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
-1 vote115 views1 answer
Text to speech vb.net
VBA