/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 vote357 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote389 views1 answer
VBA
VBA
0 vote342 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote352 views2 answers
Get excel file from email attachment in vba
VBA
0 vote381 views1 answer
Excel delete ever other vba
VBA
0 vote355 views1 answer
Show unix time in vba
VBA
0 vote369 views1 answer
Excel filter by date not working vba
VBA
0 vote336 views1 answer
Check range is in another range vba
VBA
3 votes370 views1 answer
Vba http request json
VBA
0 vote377 views1 answer
Remove last 8 characters from string vb
VBA