Monkey Tools Bug?

[Nick Burns]

Using Ver 1.0.7937.29233

Steps to reproduce:

1. Open Excel
2. Hide the current window
3. Attempt close Excel

'Monkey Tools' has fired an exception> Click the 'Details' button to see the detailed information about the error.

Details:

Detailed technical information follows: 
---
(Inner Exception)
Date and Time:         10/28/2021 01:05:30 PM
Machine Name:          [redacted]
IP Address:            [redacted]
Current User:          [redacted]


Application Domain:    C:\ [redacted]\AppData\Local\Apps\2.0\HEECTJB1.WX3\YDJHVB51.YRD\monk..ools_4dc9f9b35674fc44_0001.0000_ae9f378d53f34973\
Assembly Codebase:     file:///C:/ [redacted]/AppData/Local/Apps/2.0/HEECTJB1.WX3/YDJHVB51.YRD/monk..ools_4dc9f9b35674fc44_0001.0000_ae9f378d53f34973/MonkeyTools.dll
Assembly Full Name:    MonkeyTools, Version=1.0.7937.29233, Culture=en-CA, PublicKeyToken=a855751e545c1051
Assembly Version:      1.0.7937.29233


Exception Source:      MonkeyTools
Exception Type:        System.NullReferenceException
Exception Message:     Object reference not set to an instance of an object.
Exception Target Site: appEvents_WorkbookBeforeClose


---- Stack Trace ----
   MonkeyTools.AddinModule.appEvents_WorkbookBeforeClose(sender As Object, e As ADXHostBeforeActionEventArgs)
       AddinModule.vb: line 1598, col 13, IL 0163 (0xA3)
   AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookBeforeClose(workbook As Object, cancel As Boolean&)
       MonkeyTools.dll: N 0027 (0x1B) IL 






(Outer Exception)
Date and Time:         10/28/2021 01:05:30 PM
Machine Name:          [redacted]
IP Address:            [redacted]
Current User:          [redacted]


Application Domain:    C:\ [redacted]\AppData\Local\Apps\2.0\HEECTJB1.WX3\YDJHVB51.YRD\monk..ools_4dc9f9b35674fc44_0001.0000_ae9f378d53f34973\
Assembly Codebase:     file:///C:/ [redacted]/AppData/Local/Apps/2.0/HEECTJB1.WX3/YDJHVB51.YRD/monk..ools_4dc9f9b35674fc44_0001.0000_ae9f378d53f34973/AddinExpress.MSO.2005.DLL
Assembly Full Name:    AddinExpress.MSO.2005, Version=9.5.4661.0, Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version:      9.5.4661.0


Exception Source:      
Exception Type:        AddinExpress.MSO.ADXExternalException
Exception Message:     An error has occurred in the code of the add-in.


---- Stack Trace ----

 

[Ken Puls]

Nick, thanks for this. A couple of questions for you:
1) Can you clarify the click steps you are using for "Hide the Current Window"?
2) Does this reliably crash Excel every time, or was it a one-off?
3) Do you have any VBA-based add-ins running?

We've been trying to swat this bug for some time, and have been unable to reproduce it on our side. So the more details I can get, the more help it will be.

Thanks a ton!

 

[Nick Burns]

That's from freshly opening Excel
I only discovered it because, yes, I prematurely stopped a macro and didn't realize a hidden file was open when I attempted to close Excel.

So I tried to recreate it from fresh and still got the error.
Just hiding the workbook by using View Tab > Hide Window

I just followed the same steps again and got the exception error.

Note: I also uninstalled 32Bit Office 365 and installed 64Bit Office 365 on Monday. Should I try uninstalling/reinstalling Monkey Tools now that I'm on 64Bit?

 

[Ken Puls]

BRILLIANT! Thanks Nick, I can repro that on my side.

With regards to reinstalling, Monkey Tools, I don't believe it should be necessary. (Just try not to do what you did!)

Let me run this to ground with my team here and see if we can get this fixed once and for all. I'll post back when we've got a solution.

Cheers!