/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 vote215 views1 answer
Vb.net get name by Cell Click
VBA
0 vote205 views1 answer
Change whcih control a user has selected vb
VBA
0 vote217 views1 answer
Vba get workbook name
VBA
0 vote245 views1 answer
Filesystemobject vba reference
VBA
1 vote205 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote242 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote202 views1 answer
Returns an array from function vba
VBA
1 vote197 views1 answer
Vba delete array element
VBA
0 vote217 views1 answer
Vbscript for loop
VBA
0 vote210 views1 answer
String contins in vba
VBA