ActiveWorkbook.Close Failure

[ajorlov]

I have consistently used ActiveWorkbook.Close in my macros without problem to both close other workbooks and to close the workbook in which the code itself is contained. However, suddenly that function still works when it is being used to close a workbook other than the one containing the code but it no longer will close the workbook that contains it.

Around the time this problem emerged (several days ago) I was having a SQL Server issue, in which my trial copy expired and I had to install a new version. This is the only thing I can think of that has changed on my machine.

Thoughts? Thanks

 

[Norie]

My first thought would be not to use ActiveWorkbook in the first place.

If you want to deal with the workbook with the code in it use ThisWorkbook.

If you want to deall with others trying explicitly naming them.

If you are opening workbooks then create references to them when you open them and then use them when you want to close them.

Dim wbThis As Workbook
Dim wbOpen As Workbook
 
    Set wbThis = ThisWorkbook ' create reference to workbook containing code
    Set wbOpen  = Workbooks (C:\WorkBookToOpen.xls)
    ' code
 
    ' now lets close that workbook you opened
    wbOpen.Close