/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 vote182 views1 answer
Vba keep command window open
VBA
0 vote180 views1 answer
Remove first character from string vb
VBA
0 vote169 views1 answer
Vba border weight
VBA
0 vote183 views2 answers
Excel vba number format file size
VBA
1 vote164 views1 answer
Excel vba saveas force overwrite
VBA
0 vote228 views2 answers
Excel vba store array and write to sheet
VBA
0 vote189 views1 answer
VBA
VBA
15 votes267 views1 answer
Excel vba wait
VBA
0 vote176 views1 answer
Excel vba urlmon
VBA
6 votes185 views1 answer
Excel vba get the path of current workbook
VBA