Question : excel vba write string to text file
Answered by : daniel-ferry
'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 FunctionSource : http://academy.excelhero.com/ | Last Update : Sat, 09 May 20
Question : vba write text file
Answered by : vastemonde
Open ThisWorkbook.Path & "\log.txt" For Append As #1
Write #1, "Here is my text."
Write #1, "Another line."
Close #1Source : | Last Update : Thu, 25 Feb 21