Ok, What the macro does, it copies data from one workbook to another. The macro itself is within Workbook1.xls. Now, my macro is set up to open Workbook2, flip back to Workbook1, Copy data, flip over to Workbook2 and paste. If one of my co workers rename Workbook1... The macro cant flip back to Workbook1.xls during the macro because that file has a new name.