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 iit contains a worksheet called "CAB HDNS" (not all of them do). Then iif it does, I need to change the contents of cell M10 from X-9999 REEV 05 to X-9999 REV 07.

I also need to do the same thing in other scenarios, as well. If I can get some guidance with this one, I can modify it to suit the otthers.

Thanks!!

Explanation / Answer

In place of, or in addition to the lines

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

you can usee

             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.