Macro Stops Running

I have this code that runs the through the first 4 lines. It then stops as I describe below.

For Privacy concerns I am using generic names for workbooks

Please Login or Register  to view this content.

At this point, Unknown Workbook.xls closes but the original workbook is still open and the following Macro need to run. But the whole Macro stops at this point.

Please Login or Register  to view this content.

How do I make the original macro continue after the Unknown Workbook.xls closes and I have my original workbook still open?

Try selecting your original workbook.

Excel probably gets confused as to what the active workbook is.

So record yourself selecting the original workbook and insert that line.