Macro to find/replace in notepad

Closed
Brad - Apr 7, 2010 at 09:05 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 7, 2010 at 09:48 PM
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.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 7, 2010 at 09:48 PM
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.
0