Macro to find/replace in notepad

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I am in need of editing a text file in notepad that was created via a macro in excel. I have created the code to open the file in notepad but was wondering if there is code that will allow me to find/replace in notepad from the excel macro. Sounds ridiculous, but I am trying to overcome the special character issues with exporting a csv file.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Indirectly. What you could do is via macro open the file and read the file and replace what ever needs to be replace and write it back to a new file.