/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 vote175 views1 answer
String contins in vba
VBA
2 votes171 views1 answer
Vba file from path
VBA
6 votes164 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote160 views1 answer
Add items to combobox vb.net
VBA
0 vote164 views1 answer
Vba find last column in a row with data
VBA
0 vote161 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote153 views1 answer
Excel vba milliseconds
VBA
0 vote171 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote170 views1 answer
Vbnet check if sting contians symbols
VBA
7 votes184 views1 answer
Excerl vba array to range
VBA