/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

-1 vote239 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote211 views1 answer
Nested if else in vb.net
VBA
1 vote210 views1 answer
Add a index column power bi
VBA
2 votes209 views1 answer
Date format for ms chart vb.net
VBA
1 vote230 views1 answer
Vba optional
VBA
0 vote236 views1 answer
How to add line graph vb net
VBA
1 vote215 views1 answer
Vbscript convert ascii code to character
VBA
0 vote205 views1 answer
Vbnet hex to binary
VBA
0 vote234 views1 answer
Get month number from month name vbnet
VBA
0 vote211 views1 answer
Remove last 8 characters from string vb
VBA