I have the below code at the end of a macro after switching from workbook (A) to the MMDDYY-SGCS workbook. The entire macro runs in WB(A) then the code below switches to the MMDDYY workbook.
Windows("MMDDYY-SGCS.xlsm").Activate
Sheets("Sheet1").Select
Range("B2").Select
'Application.Run...