/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 vote317 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote339 views1 answer
Vba createparameter null
VBA
0 vote335 views1 answer
Excel text to columns line break
VBA
0 vote367 views1 answer
Vba nested dictionary
VBA
0 vote322 views1 answer
Vb net check if file exists
VBA
0 vote313 views1 answer
Vb test if reference is null
VBA
0 vote309 views1 answer
Putting marquee in vb.net
VBA
4 votes398 views1 answer
VBA Deep Clone Dictionary
VBA
5 votes368 views1 answer
Excel vba right word from Long Integer
VBA
0 vote330 views1 answer
Excel vba formatconditions positive
VBA