How to create and write to a txt file using VBA

by

Use FSO to create the file and write to it.

Dim fso as Object
Set fso = CreateObject("Scripting.FileSystemObject")
Dim oFile as Object
Set oFile = FSO.CreateTextFile(strPath)
oFile.WriteLine "test" 
oFile.Close
Set fso = Nothing
Set oFile = Nothing

See the documentation here:

  • http://technet.microsoft.com/en-us/library/ee198742.aspx
  • http://technet.microsoft.com/en-us/library/ee198716.aspx

Leave a Comment