I don't refer to it. I open it from my email, which opens it in the same instance as the others. Then I am able to run the macros that I have on the other workbooks that are open. I run a setup macro that formats the data then changes the focus to the appropriate workbook to copy it to. I just wanted to close the first workbook as it is not needed once the data is copied over. I'll try your code out to see what happens.