Since we are saving the file twice with 2 different names, whenever we use the range or sheet comments, its better to name the workbook and the sheet along with it. For e.g. if we are referring to a worksheet, we name the workbook as well. If we are referring to a range, we name the workbook and the sheet to which it pertains. This ensures that the macro works correctly and only on the workbooks we need.

So please provide the workbook names for each code.