Debugging a Visual Basic like language in VBA (Excel/ Word 2003)
Posted on 2005-04-09
I do a lot of development on a program (PSBasic) that is similar to Visual Basic but has a slightly different syntax. The development environment for PSBasic is very bad, may be similar to the old DOS basic. I have developed macros that change the code for PSBasic into VBA that can be run and debugged in Excel 2003 VBA. In addition, I use some custom functions declared in VBA and some variable declarations. Once it is debugged, I use another macro to convert back from VBA to PBasic.
Now I want to convert this method to an application. The application will be like an add-in or something similar. It will hide the macros used for converting back and forth from PSBasic to VBA. It will also hide the variable declarations and custom fuctions that I have developed. The user will be able to see the 'converted' code (PSBasic to VBA). Then debug the code as he would a VB Macro and then convert the debugged code back from VBA to PSBasic.
Before I spend a lot of time developing this,I AM LOOKING FOR SOME TIPS TO MAKE THE WHOLE PROCESS BETTER and more user friendly. I am not really worried about the cost of developing this. Only that it should be an excellent application.
One key challenge is that the syntax changing from PSBasic to VBA is difficult i.e. we are replacing on pattern of if..then..else statements with another pattern, etc.
(Please note that PSBasic is not the real name of the program that I use.)