Changing to another Workbook

destWB = ActiveWorkbook.Name
Windows(destWB).Activate

first store your current active workbook into a variable

later, use Windows().Activate to refer your previous workbook.