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

5 votes153 views1 answer
Xl vba double quotes in string literal
VBA
0 vote157 views1 answer
Putting marquee in vb.net
VBA
0 vote163 views1 answer
Return na vba
VBA
0 vote159 views1 answer
Build an index all files of a FTP site
VBA
1 vote152 views1 answer
Excel vba close form escape key
VBA
0 vote159 views2 answers
Vba remove line breaks
VBA
0 vote177 views1 answer
Visual basic run command
VBA
1 vote158 views1 answer
Vba login website
VBA
6 votes173 views1 answer
Excel vba isalpha
VBA
0 vote145 views1 answer
Vba copy paste value only
VBA