My goal is to run a macro in Book1 that will open Book2 and run a macro that will close and eventually delete Book1. My problem is that Book1's name will always be a variable. I thought (always a mistake) that I could just setup a reference to the Module to get the workbooks name which I made a public value. While that did allow me to "pass" then variable, I am not able to close Book1 now due to error of you cannot close a workbook where there is a reference. What do I do?