/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 vote115 views1 answer
Vbnet line chart showing extra space
VBA
0 vote110 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote111 views1 answer
Vba string start with
VBA
1 vote131 views1 answer
Extract the second word in a text in excel
VBA
13 votes168 views2 answers
Vba write text file
VBA
0 vote123 views1 answer
Create links in msgbox in vb
VBA
0 vote116 views1 answer
Excel vba copy range with filter
VBA
0 vote117 views1 answer
Vba change named range address
VBA
0 vote120 views1 answer
Excel vba range contains
VBA
5 votes118 views1 answer
Excel vba tool to help with refactoring code
VBA