Translate programs into Excel
Translate programs into Excel
(OP)
For a number of years I have programed in GWBASICS. I have numerous lengthy programs requiring several pages to print out. GWBASICS is becoming outmoded and few people could understand the language.
I am now trying to translate these programs into Excel. I was stumped when trying to loop and to subroutine as I used to it with Basics. I can not succefully do the logic either with the exception of the IF statement.
I am also becoming familiar with VB micros for Excel however I must become familiar with this pragram which is a pain in my attempts to do loops and subroutines.
Is there an easy way to translate my programs into Excel without the VB macros? Must I learn VB? Is there a Webb Site or good reference material that gets to the meat of the matter or must I read, learn and reference these huge books from microsoft office and visual basics?
Any help is appreciated.
I am now trying to translate these programs into Excel. I was stumped when trying to loop and to subroutine as I used to it with Basics. I can not succefully do the logic either with the exception of the IF statement.
I am also becoming familiar with VB micros for Excel however I must become familiar with this pragram which is a pain in my attempts to do loops and subroutines.
Is there an easy way to translate my programs into Excel without the VB macros? Must I learn VB? Is there a Webb Site or good reference material that gets to the meat of the matter or must I read, learn and reference these huge books from microsoft office and visual basics?
Any help is appreciated.





RE: Translate programs into Excel
RE: Translate programs into Excel
for n=1 to max
code
code
code
next
and
while n<>done
code
code
code
wend
TTFN
RE: Translate programs into Excel
with the past 6 months, i have accomplished the same task in translating gwbasic files into excel workbooks or visual basic, and i am still doing the translation. it is a simple task for me since i am knowledgeable in visual basic and excel, but it can be time-consuming for some programs. since most of my gwbasic files are equation oriented, the conversion process was as simple as copy and paste (relatively speaking).
i do not know of any "software" translation programs nor other aid web sites for you to refer to. i did have to locate a web site to obtain a list of gwbasic commands in order to complete the conversion/translation. what comes to mind is the excel equivalent of gwbasic's "sgn(xyz)" function.
try the web site: http://www.geocities.com/KindlyRat/GWBASIC.html
to obtain a command/function description list of gwbasic.
visual basic is relatively easy to learn and frankly, it may be even considered as an extension of gwbasic and ms qbasic.
good luck!
-pmover