How can I do a search and replace like this in multiple Excel files editing a common path name in macros across all Excel files?
There is an application called search and replace that allows you to perform multiple editing operations for the given files, but there is nothing specified about the Macro support while the files are opened. You will actually have to open each file to perform editing operations for the Macro scripts.
To download the search and replace application, use the following link: http://multiple-search-and-replace.software.informer.com/
