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 vote261 views1 answer
If statement vdhl
VBA
0 vote237 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote263 views1 answer
Vbnet check if string is only letters
VBA
3 votes223 views1 answer
Excel vba read registry key value
VBA
2 votes235 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote235 views1 answer
Limit combobox to list vba
VBA
0 vote248 views1 answer
Excel vba paste all to each sheet in workbook
VBA
2 votes222 views1 answer
Excel vba extract file name
VBA
0 vote237 views2 answers
How to concatenate more than 40 lines in vba
VBA
1 vote240 views2 answers
Vba function return array
VBA