Vba write 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

Vba write text file

Open ThisWorkbook.Path & "\log.txt" For Append As #1
Write #1, "Here is my text."
Write #1, "Another line."
Close #1

Similar codes

0 vote419 views1 answer
Excel vba protect scenarios
VBA
0 vote357 views2 answers
Vba remove line breaks
VBA
0 vote352 views1 answer
Compare dates vb
VBA
0 vote354 views1 answer
Vba full date format
VBA
5 votes421 views1 answer
Excel vba low word from Long Integer
VBA
6 votes399 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote426 views1 answer
Vba login website
VBA
0 vote400 views1 answer
Open file dialog in vb.net
VBA
0 vote377 views1 answer
Vbnet find highest value in chart
VBA
0 vote382 views1 answer
Vba registry settings
VBA