/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

0 vote125 views1 answer
Send webhook vbscript
VBA
2 votes113 views2 answers
Constructor vb.net
VBA
0 vote124 views1 answer
Make your computer talk vbscript
VBA
-1 vote122 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote127 views1 answer
Dynamic array vba
VBA
0 vote133 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote123 views1 answer
Vba html document reference
VBA
4 votes123 views1 answer
Vba create directory
VBA
0 vote135 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote141 views1 answer
Excel vba paste all to each sheet in workbook
VBA