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.

‘ 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)
End Function

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

More questions on [categories-list]

Similar Posts