search

cristianbuse / VBA-StateLossCallback

A class that allows a callback when state is lost
MIT License
12 stars 4 forks source link

inconsistent behavior (crash) when state is lost due to code change #7

Open thefasquelle opened 3 months ago

thefasquelle commented 3 months ago

Some code changes such as adding members to a module will reset project. Sometime the callback is called and sometime it is not, it seems pretty random. When it is called, sometime Excel crashes and sometime it doesn't. Also seems pretty random.

Also the crash is not the same depending on init method. If callback is InitByAddress, Excel freezes briefly then exit with ExitCode = 4 and restart. If callback is InitByName, Excel becomes unresponsive and just hangs forever (will I never waited more than 5 minutes tbh).

I believe this different behavior depending on init type is the same when application crash at exit so might be related to #3 ?

cristianbuse commented 3 months ago

Thanks @thefasquelle ,

There are quite a few issues raised lately. I am planning to work on this class in the next few weeks as currently am too busy. Not sure I will be able to find workarounds for some of these issues though.