Deleting conditional formatting rules from multiple workbooks

HI

I am looking for a code to delete conditional formatting rules from multiple workbooks as each of the workbooks are run.

For example when one workbook with several sheets containing various conditional formatting rules is executed, the code, should be able to delete those rules from that workbook and so on do the same with other workbooks. Please note some of the worksheets don't have any rules so it should also be able to skip those worksheets while deleting formats.

To run the first workbook i have the following code

Set myData1 = Workbooks.Open("C:\FINAL ANSWER\FOLDER4\FOLDER3\MAINDATA1\MAIN DATA.xlsm")
myData1.Save
myData1.Close

and the solution is to add some lines of code to clear those formatting rules from contained worksheets.

A sample workbook is also added.

Thank you

I don't understand what you're doing.
Why are you only opening a workbook and then close it again without doing anything (as in your attachment codes)

Or is this what you mean?

Please Login or Register  to view this content.

i tried that but it gives compiler error at the end and also it doesn't clear formatting rules from "C:\FINAL ANSWER\FOLDER4\FOLDER3\MAINDATA1\MAIN DATA.xlsm"