Answers for "excel vba write string to text file"


excel vba write string to text file

'VBA function to write string to text file:

Function SaveStringAsTextFile$(s$, fName$)
    Const adSaveCreateOverWrite = 2
    With CreateObject("ADODB.Stream")
        .Charset = "utf-8"
        .WriteText s
        .SaveToFile fName, adSaveCreateOverWrite
    End With
End Function
Posted by: Guest on May-02-2020

Code answers related to "VBA"

Browse Popular Code Answers by Language