/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 vote166 views1 answer
Vba verticalalignment
VBA
0 vote166 views1 answer
Internet explorer reference vba
VBA
0 vote174 views1 answer
Vba find sub dictionary
VBA
0 vote156 views1 answer
Excel vba populate array with cell values
VBA
0 vote182 views4 answers
Vgrive,deb
VBA
0 vote151 views1 answer
Vba argument is set
VBA
5 votes163 views1 answer
Excel formula how to create strings containing double quotes
VBA
1 vote156 views1 answer
Excel vba saveas force overwrite
VBA
0 vote163 views1 answer
Type excel.application is not defined vb
VBA
0 vote171 views1 answer
Windows Presentation Foundation dark title bar
VBA