Unable to run Excel_run_macro after pass/fail report generation step

[JoanneXue]

I am using TestStand 4.2.1 to create a test sequence. I used a sequence call - Excel_Run_Macro- to copy some data from a excel sheet (Temp_PRCR.xls) to another excel sheet (PRCR_Run_Macro_TARGET.xls) and save it as another excel file (PRCR_Run_Macro_TARGET_Out.xls). It works properly with this single step. But it's not work after a pass/fail report generatation step. Even the new file is not created in this case. I put a delay time (5second) in between it create the new excel file but it didn't copy the data properly.  

[snowpunter]

Is the new step putting additional data into the Excel sheet or modifying it in any way? The new step would seem like a red herring if it wasn't interacting with the Excel sheet.