VBA script to remove excel striked out text (partial) inside each cell.

[learningpython]

Hey Experts,

Please can I get some help ?
I have a lot of excel in different folders and each excel has a tab of test cases, in each cell of excel there are steps and that I have made changes by striking out with red font and added relevant text in red.
Now the review is done and they want to remove all the strikeout content in Each Cell (not the cell content)the text that is strikedout and retain the text I have updated with red colour.
I thought, I can seek your help to get ths easy. rather going 100s of lines in each excel.

Note: Some excel have line breaks and some have merged cells rows for headers (to be ignored).

User Input: Folder for excel

1. Tab Name:
2. From Column:
3. To Column:
4. Rows:

Expected output:

1. List It: I need to keep records of changes

1. List out in excel/csv
2. File name: Tab name:
3. 1. Cells with Red Font
4. 2. Cells with Strikeout

2. Clean it:

1. Remove the partial text in each cell where is Strikeout (Delelete only striked out text)
2. Replace red font to black

is it possible to get a VBA script for the above?

Thanks a lot

 

[learningpython]

Sorry after working with some shell not working script, I realized I need this before clean it module.
1. List It:
I need to keep records of changes
Say out is review.xlxs
Then I need a tab with file name with cell references of the strikeout font and Red Colour.

1. List out in excel/csv
2. File name: Tab name:
3. 1. Cells with Red Font
4. 2. Cells with Strikeout