vba get text file content

The solution for “vba get text file content” can be found here. The following code will assist you in solving the problem.

Get the Code! 
‘ 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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

weekday vba

Bym0nxt3r

The solution for “weekday vba” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]