/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 vote308 views1 answer
Excel named range sum
VBA
0 vote288 views1 answer
Switch pictures with buttons vb.net
VBA
6 votes326 views1 answer
Excel vba isalpha
VBA
0 vote263 views1 answer
Excel vba open browser
VBA
0 vote282 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
1 vote293 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
3 votes326 views1 answer
Vba post request json
VBA
1 vote297 views1 answer
VBA Loop through recordset
VBA
1 vote291 views1 answer
Vba reverse string
VBA
0 vote269 views1 answer
Excel vba hide columns
VBA