Guest_imported
New member
- Jan 1, 1970
- 0
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...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lotus 123 macros into excel
- Thread starter Guest_imported
- Start date
- Status
- Thread starter
- #2
Guest_imported
New member
- Jan 1, 1970
- 0
I can not view or execute the macros in excel
(assuming that they are there)
They do not show up in the Macro tool
(assuming that they are there)
They do not show up in the Macro tool
DaleWatson123321
Programmer
Mouse_Charm,
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question