Search/Replace across multiple files
Posted by Mark Parsons on January 31, 2001 5:59 AM
Houston - We have a problem!
We've got 40 separate workbooks (i.e. actual files, not sheets!) where one (one! argh!) item of text is consistently wrong on each - exactly the same place, exactly the same error.
Is there any way to either replace the error in a selection of files (don't think that there will be...) or possibly automate the loading of each workbook (all in one directory), change the cell, and re-save?
I had a bash using VBA, but couldn't quite get my brain around it! ;-/
Ta very much!