ActiveWorkbook.Close issues

[WadeLair]

I'm having some trouble with the ActiveWorkbook.Close actions in Excel VBA.

The macro is closing the ControlFile instead of the active sheet. Is there another way to do this or does anyone know where I am going wrong in the code?

Please Login or Register  to view this content.

[Norie]

Which workbook do you actually want to close?

There seems to be 3 workbooks involved in the code, 2 that you open and 1 that presumambly is already open.

One thing you could do to keep track of the workbooks is set variables that refer to them

For example:

Please Login or Register  to view this content.

You can use a reference like this to refer to this workbook in the code.

For example to close it.

Please Login or Register  to view this content.

[WadeLair]

Thanks, I'm going to try that. It's a great idea!