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:

More Related Contents:

  1. Text file in VBA: Open/Find Replace/SaveAs/Close File
  2. How do you extract email addresses from the ‘To’ field in outlook?
  3. to make this code simpler
  4. Does VBA have Dictionary Structure?
  5. Get reference to additional Inbox
  6. VBA, ADO.Connection and query parameters
  7. How do I trigger a macro to run after a new mail is received in Outlook?
  8. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  9. Is there a need to set Objects to Nothing
  10. Code in VBA loops and never ends. How to fix this?
  11. Excel column number from column name
  12. Pop up the Excel Statusbar?
  13. How To Speed Up VBA Code
  14. Execute a command in command prompt using excel VBA
  15. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  16. VBA Shell and Wait with Exit Code
  17. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  18. Load csv file into a VBA array rather than Excel Sheet
  19. Insert line break in wrapped cell via code
  20. MS Access: how to compact current database in VBA
  21. Can I Get the Source Range Of Excel Clipboard Data?
  22. Using visual basic to access subfolder in Inbox?
  23. How to create dynamic variable names VBA
  24. How to break a long string into multiple lines
  25. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  26. finding latest file in a folder and opening it (vba access)
  27. reading and writing a csv file using FileSystemObject
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment