Trouble closing an Excel file

[GraeagleBill]

I can't figure out what's going on with the situation depicted in the screenshot below? Any ideas?

[ranman256]

it means XLSAPP was erased.
most likely set xlsapp = nothing.

dont set that until AFTER the close and save.

[GraeagleBill]

dont set that until AFTER the close and save.

I don't understand your note in that you'll see in the code that I don't set the object of Nothing until after the save.

If I remove "SaveChanges:=False" and let the close disposition default it works fine, so the problem lies elsewhere.

[Micron]

do you have xlsApps declared at the very top of your module? I don't see how Form_Close knows what it is.
EDIT:
I also think the syntax is .Close False but not sure. What you have looks more like Excel syntax.
Then again, you don't specify which workbook in the Workbooks collection you are trying to close. You specify which one to add to the collection (sgtrxlFileName) but not which one to close. When doing this, I always create objects for the app, book, and sheet. That way, it's clear and easy as to which one I want to refer to. Haven't done this for a while so I'm guessing a bit, but I lean towards Access not knowing which object to close.

[GraeagleBill]

Turns out I have to close each Workbook in the collection one at a time. xlsApp object is DIM'd, Set and Open elsewhere in the module. You'll notice the the code doesn't run unless the Workbook is open boolean is True.

If bolWSOpen Then
    
    For Each WB In xlsApp.Workbooks
        WB.Close SaveChanges:=False
    Next
    xlsApp.Quit
    Set xlsApp = Nothing
    
End If