/VBA/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"
        .Open
        .WriteText s
        .SaveToFile fName, adSaveCreateOverWrite
    End With
End Function

Source: academy.excelhero.com

Similar codes

5 votes229 views1 answer
Xlvba double quotes in string literal
VBA
0 vote224 views1 answer
Average vba
VBA
0 vote207 views1 answer
Docker vboxmanage not found
VBA
5 votes238 views1 answer
Xl vba double quotes in string literal
VBA
0 vote228 views1 answer
Not allow form to be resized
VBA
0 vote229 views1 answer
Vba dictionary clear
VBA
0 vote248 views1 answer
Vbs run with cscript
VBA
0 vote254 views2 answers
Excel vba number format file size
VBA
1 vote217 views1 answer
Excel vba close form escape key
VBA
6 votes224 views1 answer
Excel vba check if a string only contains letters
VBA