I am trying to convert an Excel 2003 VBA macro to LibO. I have fixed the few syntax problems. The heart of the conversion effort will be in dealing with the two very different APIs. My preference is to Open the Excel xla file and have it run until the first runtime error, which I would then fix. I would repeat the cycle of “run and fix” for the other errors. When I encounter an error, I would also search for and fix similar errors, in order to speed up the conversion effort.
My problem is that the Basic processor often does not provide the error information that I need. The first error message says, BASIC runtime error. ‘420’ Invalid object reference. The end of the module’s code is displayed, but there is no code highlighted or arrow pointing to a particular line. I have no idea which object the Basic processor is complaining about. Pressing the Stop Macro button has no effect. When I press the OK or X button on the message, the macro continues to the next error. That error is, BASIC runtime error. ‘12’ xlApplication Event. But even without me dismissing the message, the processor continues to the next error after a few seconds
I have placed many breakpoints in the code, but this does not seem to help me in isolating the errors.