Excel Macros
FSt1 has provided the answer to the 1st half of your question.
How are you doing the search/replace - manually from the keyboard, or in
code? Are you searching the .txt file created or something else?
"Chris Premo" wrote:
I'm saving my data as a Text file and use
this command. Unfortunately, it prompts for a use action to
save/replace the file and then prompts again when I close the file.
I'd like code that would not require use intervention.
ActiveWorkbook.SaveAs Filename:="I:\Configs\" & TextStr2,
FileFormat:= xlText, CreateBackup:=False
ActiveWorkbook.Close
Also, I'm trying to search and replace for a string of like this:
****************************************
Unfortunately, it is using this as a wildcard and finds all text. How
can I search for this exact string and only replace this string????
--
|