Translate programs into Excel

[chicopee]

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.

 

[IFRs]

I had a real investment in BASIC programs for estimating, engineering and inventory control. I had to convert them to Microsoft QuickBasic which was not hard and then to Microsoft Visual Basic which was tedious but not hard. Now I'm fully into Visual Basic and I really really hope that Microsoft does not abandon Visual Basic until I retire.

 

[IRstuff]

Most of the constructs as far as object referencing can be learned by doing macro recordings. If you look in the Visual Basic Help, it should have the looping construction, which ought to look something like:

for n=1 to max
code
code
code
next

and

while n<>done
code
code
code
wend TTFN

 

[pmover]

chicopee,

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 &quot;software&quot; 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 &quot;sgn(xyz)&quot; 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