I have a couple of saved cases where Excel behaved very badly. In a very weird manner.
I am a Software Engineer with over twenty years professional programming experience. Mainly embedded systems, such as medical instruments & robotics systems. Designing Operating systems and drivers. For the last ten years or so I have turned into a consultant for big Pharma, so have stopped programming for my bread.
I am not what I would consider to be a professional Excel Developer (although I have gotten paid for some work on Excel/VBA). But I have a decade of experience programming in C and Windows and have a basic understanding of the PC. Windows API does not phase me.
I have an example of an "Error", -and I don't have the tools to track down what is actually going on to diagnose where the error lies. -It looks, feels & smells like a bug in Excel.
If anyone with appropriate debbuggers, simulators, emulators are interested, OR if this forum is interested, I can post the details.
It's very complicated, long and might make tedious reading, so I want to know if this is on-topic for readers of this forum.
In twenty five words or less: When starting up a excel there is some linkage between the existance of document properties and failure of Workbook_Open() to run.
Please don't respond to the statement above with suggestions -There is a ton of information and over two months were expended on this problem in various Excel forums with no results. Like I said, this is a weird problem. If this is the forum, I will be happy to post everything except the file. There is proprietary information in the actual failing example I have, and would only be comfortable sending it directly to someone interested in seeing the problem.
Feedback appreciated!