/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 vote169 views1 answer
Excel vba round to whole number
VBA
-1 vote137 views1 answer
Text to speech vb.net
VBA
2 votes154 views1 answer
Vba round number
VBA
1 vote141 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote163 views1 answer
Vba table header name
VBA
0 vote161 views1 answer
Excel last used row
VBA
0 vote145 views1 answer
Vbs exec hidden
VBA
0 vote141 views1 answer
Change "location" of binding navigator vb
VBA
1 vote153 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
2 votes156 views2 answers
Vba code to remove duplicates from a column
VBA