I am wanting to perform a Find/Replace on all the excel files in a single folder
(that I am prompted to select.)
This is the code:
Sub Find_Replace1() Range("A2:A100000").Replace What:="MyTextString1", Replacement:="MyTextString2" End Sub
How do I open, change, close on all the files in one folder?
I do not know how to program in VBA
New contributor
PatRat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.