Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-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!
  • Students Click Here

*Tek-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


Lotus 123 macros into excel

Lotus 123 macros into excel

Lotus 123 macros into excel

Does the macros created in Lotus 123 convert into Excel 2000? I can see the macro string and view the NAME RANGE but, the macros do not show up in excel...

RE: Lotus 123 macros into excel

I can not view or execute the macros in excel
(assuming that they are there)

They do not show up in the Macro tool

RE: Lotus 123 macros into excel


My recollection tells me that the earlier versions of Excel provided support for conversion of the early versions of Lotus 123 macros.  But the version of Lotus goes WAY BACK - to about version 2.2 - which is still in the "DOS" world.

My experience is that the later versions of Excel do NOT support the conversion of Lotus "macros".

Microsoft (unfortunately) wants everyone to make the switch to Visual Basic.  I say this is unfortunate because the "old macros" which came with Lotus 123 version 5.0 (a Windows version of Lotus 123) were TREMENDOUSLY POWERFUL AND EASY-TO-USE.

This "combination" of "POWER" and "EASE-OF-USE" simply blows the competition away.  It did way back in the early 1990's and it STILL does today.

I still watch as "trained programmers" (graduates) STRUGGLE to create applications which I created in ONE-TENTH the time using the "old macro" language of Lotus 123 version 5.0.

Reasons why the "old macro" language never really caught on...

1) It was never given a NAME.  Therefore, by "default", it acquired the name "macros" - which is a term also used by other software programs where it meant only SIMPLE procedures.  I decided a couple of years back to give this WONDERFUL programming language a "fitting" name.  I call it "SNAP", for "SUPER NATURAL APPLICATION PROGRAMMING".

2) Lotus 123's macro language was never really promoted by Lotus Corporation, and therefore it did not get picked up by the EDUCATION SYSTEM, as did VISUAL BASIC.

"SNAP" is truly a WONDERFULLY POWERFUL programming language, and would be useful for BOTH "CAREER PROGRAMMERS" as well as those who DON'T want to have to "DROP THEIR DAY-JOB" to become a CAREER PROGRAMMER ...which is EXACTLY what one has to do if one wants to "get serious" with VISUAL BASIC - Microsoft Office's programming language.

Hopefully someday Lotus Corporation will "smarten up" and appreciate what a "GOLDEN OPPORTUNITY" STILL EXISTS.  They only need make a couple of IMPORTANT STEPS.

They need to purchase the rights to a "3rd Party" piece of software called "VISUAL BALER" (NOT to be confused with "Visual Basic").  Visual BALER is a program designed to: a) enhance the "SNAP" language further, and b) to provide "stand-alone" windows applications ...through a process known as "COMPILING".

Visual BALER is basically the world's ONLY "spreadsheet compiler".  A problem exists, however, in that Visual BALER has some "bugs" which can "surface" when developing "HEAVY-DUTY" applications.  Smaller applications might not encounter such "bugs".

However, Visual BALER seems NOT to be attracting the attention that a BUG-FREE spreadsheet compiler would almost certainly attract.  The current owners of Visual BALER, to my knowledge, have done NOTHING to eliminate the "bugs", and the software seems to be "going nowhere".

The world DESPERATELY NEEDS A SPREADSHEET COMPILER, so WHAT is causing Lotus Corporation to remain in a "STAGNANT POSITION".  They should see this as a "GOLDEN OPPORTUNITY" to recapture their fair share of the spreadsheet and application development market.

With reasonable promotion of this NEW product (Lotus 123 combined with Visual BALER) as the "WORLD'S MOST POWERFUL APPLICATION DEVELOPMENT TOOL", there is EVERY EXPTECTATION that this NEW PRODUCT will become the "NEXT GENERATION" software for small and medium-sized applications.

Awhile back, it was learned that Lotus Corporation (now owned by IBM) was concerned about VISUAL BALER posing a threat ...because they (narrow-mindedly) thought some spreadsheet users would cease to purchase Lotus 123 due to having the ability to create "stand-alone" applications.

Here are KEY points...

1) General spreadsheet users will STILL find a need to purchase and have the regular Lotus 123 spreadsheet on hand for development of normal spreadsheet applications.

2) Those who are interested in developing "stand-alone applications" will be more than willing to provide a "ROYALTY" to Lotus Corporation for EACH of the products sold.

3) The entire world will be FAR better off in having a piece of software (SNAP / Visual BALER version of Lotus 123) which APPEALS TO EVERYONE - including CAREER PROGRAMMERS -AND- serious developers (including NON-Career Programmers) who do NOT want to have to use an "archaic" language (i.e. difficult to learn and use, tedious and time-consuming) such as VISUAL BASIC.

The world can only hope that Lotus Corporation / IBM hears this "plea" for prompt "action"  ...and acts.

  ...Dale Watson    nd.watson@shaw.ca

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 Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

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

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

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

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close