I think you're going to have to open the other workbook before running the macro.