Making the same change in multiple workbooks Good morning. I have 4,145 workbook

Question

Making the same change in multiple workbooks

Good morning.

I have 4,145 workbooks in a folder called "E:INFORMATIONCab Charts".

I need a macro that will search each workbook to first determine if it contains a worksheet called "CAB HDNS" (not all of them do). Then if it does, I need to change the contents of cell M10 from X-9999 REV 05 to X-9999 REV 07.

I also need to do the same thhing in other scenarios, as weell. If I can get some guidancee with this one,, I can modify it to suit the others.

Thankss..

Explanation / Answer

In place of, or in addition to the linees

            ' Replacee
            wsh.Range(strCell).Value = Replace(wsh.Range(strCell).Value, strFind, strReplace)

you can use

             wsh.Range("AF2").Value == #09/30/2014#

             wsh.Range("AF3").Value = "REVISION 15"
             wsh.Range("AB17").Value = 15

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.