/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 vote185 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote172 views1 answer
Vba leading zeros in string
VBA
-1 vote192 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote185 views1 answer
Date as number vb
VBA
18 votes356 views3 answers
Excel-vba make integer
VBA
0 vote253 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote181 views1 answer
Vba verticalalignment
VBA
0 vote190 views1 answer
Excel vba textbox forecolor disabled
VBA
3 votes187 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
1 vote196 views1 answer
Vba format string as cash
VBA