I think I am doing it all wrong

[counihan3]

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?

 

[Norie]

Where is the code located?

You can close the workbook it's in like this.

ThisWorbook.Close

 

[counihan3]

I tried that I am still getting the error about closing a workbook that is refenced. I think that I need to start over with my code. I just do not know how to move a variable from one workbook to another. In this case it is the workbooks name. So that the next macro will be able to delete it once it is done running.