I've got cells in a spreadsheet showing 'Err:507' Where do I find the descriptions for these error codes? Also I'm also seeing: "Basic runtime error. '6' Overflow." How to find what's causing this error? Thanks, Mike
For the cause of the Basic error, you have to debug the macro. I guess, you can find a lot of tips on debugging programs on the Internet.
This module has 92 macros in it. It’s a stock tracking spreadsheet from Excel.
Before trying to convert to LibreOffice Calc, I would download today’s closing quotes into quotes.csv then in Excel all I had to do was enter ‘Control-q’ and the quotes would be imported and calculations run.
When I run a macro I get the " BASIC runtime error. ‘6’ Overflow." message in a popup window.
Scrolling through the module’s listing there is nothing highlighted to indicate where the problem might lie…
Click OK and the macro runs without error.
How do I find where the overflow is?
Whether the macro I call inserts a new column or simply selects a range of cells the error window pops up, the cursor in the IDE jumps to the bottom of the module and the macro does what I expect what I expect with no problems.
I’ve already removed every macro/sub that called functions that I know VBA has that starbasic doesn’t and that’s a time consuming task.
Further suggestions welcome.
Thanks,
Mike
It came to me in the middle of the night that this is what was causing the overflow.
Public Const blue As Integer = &h3465a4
It should have been declared as a Long.
Why the IDE didn’t show where the problem was is beyond me.
None the less, this problem solved.
@MikeMcClain46: on this site, solved questions are flagged by clicking on the gray check mark (only once!) of the correct answer so that this flag is forwarded on the home page.
But according to your previous comment, you should answer your own question explaining the incompatibility between your declaration and the data you put into the variable.
Thanks, Opaque.
That will help.
Mike
Opaque’s answer, above, answered the first part of this.
The second was due to my declaration :
Public Const blue As Integer = &h3465a4
It should have been declared as a Long because the number is too big to fit in an Integer.
Thanks to ajlittoz for the pointer.
Be Well, Mike