/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

1 vote252 views1 answer
Find and replace textbox
VBA
1 vote226 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
5 votes245 views1 answer
Vba low byte from INTEGER
VBA
0 vote261 views1 answer
If statement vdhl
VBA
8 votes318 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote248 views1 answer
Find database connection string vb
VBA
0 vote333 views2 answers
VB
VBA
0 vote233 views1 answer
Excel vba open browser
VBA
0 vote241 views1 answer
Vba search string position
VBA
2 votes243 views1 answer
Excel vba check if key is in collection
VBA