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 vote165 views1 answer
Set column width of datagridview vb.net
VBA
1 vote174 views1 answer
Vba format string as cash
VBA
0 vote172 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote151 views1 answer
Excel vba concatenate range
VBA
3 votes171 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote178 views1 answer
Excel vba named range exists
VBA
-1 vote167 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote171 views1 answer
Excel vba set cell value to empty
VBA
0 vote170 views1 answer
VBA Sort RossetaCode
VBA
4 votes170 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA