If the ActiveWorkbook is the workbook the code is in, then it's closing
itself and if there is any code on down in the routine that references the
workbook, there's nothing to reference.

ActiveWorkbook.Close should not shut down Excel - it should simply close the
active workbook. Application.Quit will shut down Excel itself - again,
potentially a risky action unless you know it's the last command to be
executed.

"looper" wrote:

ActiveWorkbook.Close closes Excel as desired but blows up and pops up excel
has encountered a problem send report? What would cause this to blow up Excel?