/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 vote145 views1 answer
How to format a textbox as date vb net
VBA
0 vote151 views1 answer
Excel vba disable keyboard input
VBA
0 vote162 views1 answer
Vba dictionary clear
VBA
1 vote159 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
2 votes109 views2 answers
Vba exit loop
VBA
0 vote148 views1 answer
Vbnet get file name from path
VBA
0 vote160 views1 answer
Remove series name from legendvbnet
VBA
3 votes154 views1 answer
Vba request json
VBA
0 vote189 views1 answer
Vba userform textbox wrap text
VBA
0 vote184 views1 answer
Check if cell is dbnullvb.net
VBA