/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 vote243 views1 answer
Excel vba last row of range
VBA
1 vote235 views1 answer
Excel vba saveas force overwrite
VBA
1 vote227 views1 answer
Excel vba compare 2 rows
VBA
0 vote256 views1 answer
For each item in folder outlook vba
VBA
3 votes229 views1 answer
Vba make long from two shorts
VBA
4 votes222 views1 answer
Excel formula for last non-empty cell in a column
VBA
1 vote246 views1 answer
Extract the second word in a text in excel
VBA
0 vote172 views1 answer
Vba select file in folder
VBA
4 votes229 views2 answers
Vba array length
VBA
0 vote246 views1 answer
Excel last used row
VBA