[libreoffice-users] BASIC Runtime Errors

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 in Calc 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.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted