×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Translate programs into Excel

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.

RE: Translate programs into Excel

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.

RE: Translate programs into Excel

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

RE: Translate programs into Excel

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 "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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close