/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

0 vote199 views1 answer
Supprimer la valeur de celule vba
VBA
1 vote135 views1 answer
How to open cmd with vbd
VBA
0 vote204 views1 answer
Iterate all file in a folder vba
VBA
3 votes192 views1 answer
Extract the nth word from a text string
VBA
1 vote189 views1 answer
Vbscript convert ascii code to character
VBA
8 votes403 views1 answer
Vba convert 2 bytes to an integer
VBA
2 votes185 views2 answers
Vba code to remove duplicates from a column
VBA
31 votes389 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote199 views2 answers
Open url from vba
VBA
0 vote183 views1 answer
Vbscript abs
VBA