Text file in VBA: Open/Find Replace/SaveAs/Close File

by

Guess I’m too late…

Came across the same problem today; here is my solution using FileSystemObject:

Dim objFSO
Const ForReading = 1
Const ForWriting = 2
Dim objTS 'define a TextStream object
Dim strContents As String
Dim fileSpec As String

fileSpec = "C:\Temp\test.txt"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTS = objFSO.OpenTextFile(fileSpec, ForReading)
strContents = objTS.ReadAll
strContents = Replace(strContents, "XXXXX", "YYYY")
objTS.Close

Set objTS = objFSO.OpenTextFile(fileSpec, ForWriting)
objTS.Write strContents
objTS.Close

More Related Contents:

  1. How to create and write to a txt file using VBA
  2. How do you extract email addresses from the ‘To’ field in outlook?
  3. to make this code simpler
  4. Save text file UTF-8 encoded with VBA
  5. Outlook VBA – Run a code every half an hour
  6. Excel VBA deleting rows in a for loop misses rows
  7. Can I iterate through all Outlook emails in a folder including sub-folders?
  8. Download attachment from Outlook and Open in Excel
  9. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  10. Embed picture in outlook mail body excel vba
  11. How to check for empty array in vba macro [duplicate]
  12. Where does VBA Debug.Print log to?
  13. VBA Adding a class to a collection [duplicate]
  14. MS Access VBA Error: Run time error ’70’ Permission Denied
  15. What is the function of FormulaR1C1?
  16. Compiler Error: User-defined types not defined
  17. Rounding a number to the nearest 5 or 10 or X
  18. Change color of certain characters in a cell
  19. How to insert text into Outlook email editor using VBA
  20. MS Access: how to compact current database in VBA
  21. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  22. Can I Get the Source Range Of Excel Clipboard Data?
  23. Using visual basic to access subfolder in Inbox?
  24. How to create dynamic variable names VBA
  25. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  26. simple vba code gives me run time error 91 object variable or with block not set
  27. How to get the procedure or function name at runtime?
  28. Copy an array reference in VBA
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment