Lizzynashuk
Technical User
I've never used Lotus Script b4, so I have no Idea how to do this. I want a script for a button in lotus 123 to make it run a pre-recorded script "Weekly_Activites_Report". Any help would be great. Cheers!
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 Script to run other Lotus Script
- Thread starter Lizzynashuk
- Start date
- Status
DaleWatson123321
Programmer
Hi Lizzynashuk,
I have been monitoring this Lotus SmartSuite Forum for some time, and have noticed that it gets VERY LITTLE USE - check the number of members. So, don't expect a response any time soon. In fact, I am choosing to respond "out of sympathy" because I suspect that without my response, you would possibly receive NO responses.
As for your question about using LotusScript, many Lotus 123 users who learned to use Lotus 123's longstanding programming language, have elected to stick with that language for development of serious programming applications - simply because it is FAR SUPERIOR to LotusScript. Why ? - becuase it is BOTH POWERFUL AND EASY TO USE - unlike some other languages such as LotusScript, Visual Basic and others which might be powerful, but are EXTREMELY DIFFICULT to use, AND therefore exceedingly more TIMECONSUMING because of that level of difficulty.
Lotus 123's initial language was actually "nameless", and acquired the "no-name" of "MACRO" language. This HUGE OVERSIGHT (of not giving it a name) on the part of Lotus Corporation (now IBM), was compounded by their more recent decision to abandon that WONDERFUL programming language in favour of LotusScript.
Incidentally, I have come to refer to Lotus 123's initial programming language as "SNAP", which stands for "SUPER NATURAL APPLICATION PROGRAMMING", which is somewhat more meaninful and appropriate than "macros".
As a last point, let me draw your attention to another interesting and relevant situation the IT world is in.
For application development of small to medium size applications, there was none better than Lotus 123. The main "missing ingredient", however, has always been the lack of ability to "compile" such applications into stand-alone, tamper-proof applications. This "void" was initially filled by a software company called "Baler Corporation" which had developed a DOS-based "spreadsheet compiler" which worked fairly well in the DOS world. In fact, they had added a number of security features and other features which, when added to Lotus 123, made for a TERRIFIC product.
However, when "Baler" attempted to make the jump to the Windows world, the "hurdle" and expense of conversion was too great, and forced the company into bankruptcy.
They did succeed in producing a Windows version of their product, called "Visual Baler", but it was frought with too many bugs to become a viable product. This was extremely unfortuate, because if it were "bugless", it had the potential, and still does, to become the PREMIERE application development tool in the world - even TODAY.
Unfortunately, Visual Baler was bought out by a company which appears to have done NOTHING - except to continue to offer the product (Visual Baler 2.5) which STILL contains these bugs.
What is REQUIRED for this product to succeed BEYOND EVERYONE'S WILDEST DREAMS, is to have Lotus/IBM "team-up" with the current owners of Visual Baler. If this were to happen, "the sky is the limit" in terms of conquering the programming world.
So, what can we do in the meantime ? ...suffer, suffer, suffer, while attempting to (painstakingly) program applications using LotusScript or Visual Basic.
On the brighter side, however, there has been recent talk (on the iternet forum for Visual Baler users) of a financier having expressed interest in developing a new 32-bit version of Visual Baler. I hope this comes to fruition, but I believe that any reasonable degree of success can ONLY be achieved by Visual Baler being "matched-up" with Lotus 123 (as an add-on) to provide THE WORLD'S PREMIERE PROGRAMMING SOFTWARE.
Lotus/IBM has been known to have concerns about losing market share because of some end-users using "compiled" spreadsheets instead of purchasing their Lotus 123. Well, guess what, Lotus HAS ALREADY lost the huge lead they once had in the spreadsheet world. And, as for "compiled" spreadsheets becoming a threat, Lotus/IBM/Baler can incorporate conditions of sale which would require developers to contribute "royalties" for each compiled product sold. Developers such as myself would glady agree to such royalties. It would be a small price to pay for gaining use of the BEST PROGRAMMING TOOL in the World.
Let's hope that Lotus/IBM and the Visual Baler owners/investors "tune in" to this type of wavelength, and come through for the sake of programmers who, in the meantime, continue to struggle with Visual Basic and LotusScript.
I hope this has been enlightening, and perhaps you might want to submit a copy of this to Lotus/IBM/Baler, in the hope that it might spurn them on to develop this "NEXT GENERATION" software. The world awaits......
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
I have been monitoring this Lotus SmartSuite Forum for some time, and have noticed that it gets VERY LITTLE USE - check the number of members. So, don't expect a response any time soon. In fact, I am choosing to respond "out of sympathy" because I suspect that without my response, you would possibly receive NO responses.
As for your question about using LotusScript, many Lotus 123 users who learned to use Lotus 123's longstanding programming language, have elected to stick with that language for development of serious programming applications - simply because it is FAR SUPERIOR to LotusScript. Why ? - becuase it is BOTH POWERFUL AND EASY TO USE - unlike some other languages such as LotusScript, Visual Basic and others which might be powerful, but are EXTREMELY DIFFICULT to use, AND therefore exceedingly more TIMECONSUMING because of that level of difficulty.
Lotus 123's initial language was actually "nameless", and acquired the "no-name" of "MACRO" language. This HUGE OVERSIGHT (of not giving it a name) on the part of Lotus Corporation (now IBM), was compounded by their more recent decision to abandon that WONDERFUL programming language in favour of LotusScript.
Incidentally, I have come to refer to Lotus 123's initial programming language as "SNAP", which stands for "SUPER NATURAL APPLICATION PROGRAMMING", which is somewhat more meaninful and appropriate than "macros".
As a last point, let me draw your attention to another interesting and relevant situation the IT world is in.
For application development of small to medium size applications, there was none better than Lotus 123. The main "missing ingredient", however, has always been the lack of ability to "compile" such applications into stand-alone, tamper-proof applications. This "void" was initially filled by a software company called "Baler Corporation" which had developed a DOS-based "spreadsheet compiler" which worked fairly well in the DOS world. In fact, they had added a number of security features and other features which, when added to Lotus 123, made for a TERRIFIC product.
However, when "Baler" attempted to make the jump to the Windows world, the "hurdle" and expense of conversion was too great, and forced the company into bankruptcy.
They did succeed in producing a Windows version of their product, called "Visual Baler", but it was frought with too many bugs to become a viable product. This was extremely unfortuate, because if it were "bugless", it had the potential, and still does, to become the PREMIERE application development tool in the world - even TODAY.
Unfortunately, Visual Baler was bought out by a company which appears to have done NOTHING - except to continue to offer the product (Visual Baler 2.5) which STILL contains these bugs.
What is REQUIRED for this product to succeed BEYOND EVERYONE'S WILDEST DREAMS, is to have Lotus/IBM "team-up" with the current owners of Visual Baler. If this were to happen, "the sky is the limit" in terms of conquering the programming world.
So, what can we do in the meantime ? ...suffer, suffer, suffer, while attempting to (painstakingly) program applications using LotusScript or Visual Basic.
On the brighter side, however, there has been recent talk (on the iternet forum for Visual Baler users) of a financier having expressed interest in developing a new 32-bit version of Visual Baler. I hope this comes to fruition, but I believe that any reasonable degree of success can ONLY be achieved by Visual Baler being "matched-up" with Lotus 123 (as an add-on) to provide THE WORLD'S PREMIERE PROGRAMMING SOFTWARE.
Lotus/IBM has been known to have concerns about losing market share because of some end-users using "compiled" spreadsheets instead of purchasing their Lotus 123. Well, guess what, Lotus HAS ALREADY lost the huge lead they once had in the spreadsheet world. And, as for "compiled" spreadsheets becoming a threat, Lotus/IBM/Baler can incorporate conditions of sale which would require developers to contribute "royalties" for each compiled product sold. Developers such as myself would glady agree to such royalties. It would be a small price to pay for gaining use of the BEST PROGRAMMING TOOL in the World.
Let's hope that Lotus/IBM and the Visual Baler owners/investors "tune in" to this type of wavelength, and come through for the sake of programmers who, in the meantime, continue to struggle with Visual Basic and LotusScript.
I hope this has been enlightening, and perhaps you might want to submit a copy of this to Lotus/IBM/Baler, in the hope that it might spurn them on to develop this "NEXT GENERATION" software. The world awaits......
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
>> have been monitoring this Lotus SmartSuite Forum for some time, and have noticed that it gets VERY LITTLE USE - check the number of members. So, don't expect a response any time soon. <<
This is a fairly new forum - the existing Lotus Discussion areas are quite active as is a site named XpertSS.com. I try to check in here a couple of times a week to help with Lotus Approach, which I consider to be the BEST DEVELOPMENT SYSTEM. It also lacks a compiler, but I actually sell this as a BENEFIT with my order entry products. See for examples.
Sue Sloan
This is a fairly new forum - the existing Lotus Discussion areas are quite active as is a site named XpertSS.com. I try to check in here a couple of times a week to help with Lotus Approach, which I consider to be the BEST DEVELOPMENT SYSTEM. It also lacks a compiler, but I actually sell this as a BENEFIT with my order entry products. See for examples.
Sue Sloan
Guest_imported
New member
- Jan 1, 1970
- 0
Hi Sue Sloan,
Thanks for contributing to THIS forum. As you can see, it needs some support.
As for your choice of Approach as "the BEST DEVELOPMENT SYSTEM", I don't question for a moment that it is indeed the case ...but for YOUR SPECIFIC type of application, just as Lotus 123/Visual Baler is (would be) THE BEST for MY type of application.
More specifically, your application is more "database-specific", whereas my application is more "number-crunching" and "data manipulation" specific. My application happens to be a very complex ESTIMATING program which simply could not be handled by any of the other programming environments. This point is supported "in spades" by the fact that NO ONE in the world has yet created a program which comes even remotely close to achieving the level my program has achieved. The industry has confirmed that they have been waiting for my type of program. Many consumers have spent $3,000 or more for programs which do not come close to meeting their requirements. Mine DOES meet their requirements. In fact it will revolutionize their industry, once it can be properly packaged and distributed. I had hoped this could include compiling.
I can only conclude from this that "SNAP" (the Super Natural Application Programming Language ...my name for Lotus 123 macros, and Visual Baler) is indeed the key factor which has permitted me to create this program which no others could touch.
Again, I congratulate you on your success, but unfortunately, Lotus Approach would simply "not cut it" for my type of application. I therefore am "venting my opinion" in the hope that "someone out there" (hopefully Lotus/IBM and/or Visual Baler owners) will appreciate that THERE STILL IS PLENTY OF ROOM FOR IMPROVEMENT in the development of powerful, yet easy-to-use APPLICATION-DEVELOPMENT software ...which can be COMPILED. Specifically, I am hopeful that Lotus/IBM will team up with the owners of Visual Baler.
Thanks, Sue, for listening. And thanks also to any other readers of this message.
Regards, Dale Watson nd.watson@home.com
Thanks for contributing to THIS forum. As you can see, it needs some support.
As for your choice of Approach as "the BEST DEVELOPMENT SYSTEM", I don't question for a moment that it is indeed the case ...but for YOUR SPECIFIC type of application, just as Lotus 123/Visual Baler is (would be) THE BEST for MY type of application.
More specifically, your application is more "database-specific", whereas my application is more "number-crunching" and "data manipulation" specific. My application happens to be a very complex ESTIMATING program which simply could not be handled by any of the other programming environments. This point is supported "in spades" by the fact that NO ONE in the world has yet created a program which comes even remotely close to achieving the level my program has achieved. The industry has confirmed that they have been waiting for my type of program. Many consumers have spent $3,000 or more for programs which do not come close to meeting their requirements. Mine DOES meet their requirements. In fact it will revolutionize their industry, once it can be properly packaged and distributed. I had hoped this could include compiling.
I can only conclude from this that "SNAP" (the Super Natural Application Programming Language ...my name for Lotus 123 macros, and Visual Baler) is indeed the key factor which has permitted me to create this program which no others could touch.
Again, I congratulate you on your success, but unfortunately, Lotus Approach would simply "not cut it" for my type of application. I therefore am "venting my opinion" in the hope that "someone out there" (hopefully Lotus/IBM and/or Visual Baler owners) will appreciate that THERE STILL IS PLENTY OF ROOM FOR IMPROVEMENT in the development of powerful, yet easy-to-use APPLICATION-DEVELOPMENT software ...which can be COMPILED. Specifically, I am hopeful that Lotus/IBM will team up with the owners of Visual Baler.
Thanks, Sue, for listening. And thanks also to any other readers of this message.
Regards, Dale Watson nd.watson@home.com
frostie333
IS-IT--Management
Hi Guys, this is my inaugeral post so I must apologise upfront for the lack of any real help given.
Lizzy the question you ask seems disarmingly simple and as I am a total novice I will offer my advice for what its worth.
If the prerecorded script is already existant in the spready then add a button, this should put you in script editor mode and put a single line 'call FunctionN ' where FunctionN is the prerecorded script. When the button is pressed the script will be called, I hope.
I have been toying with Approach(97) recently and I wanted to add a script call to a macro and although this is supposed to be possible using macro command 'run' the scripts I have written do not seem visible to this option.
I have to concur with Dale that the Lotusscript environment is very hard to get into as a casual user and I have concluded that I will have to buy a book or some other drastic action. This is a bit annoying when all I wanted to do was to change the background colour of a rectangle on a form dependant upon some value on the form. I found it very hard to work out intuitively how to refer to form objects and the help was not that helpful. Whenever I write a script and attempt to run a script from the editor the message Cannot Run this ???? is displayed whether there are any errors or not? Oh well I have a learning curve to try and surmount speak to you guys soon.
Regards Pete
Lizzy the question you ask seems disarmingly simple and as I am a total novice I will offer my advice for what its worth.
If the prerecorded script is already existant in the spready then add a button, this should put you in script editor mode and put a single line 'call FunctionN ' where FunctionN is the prerecorded script. When the button is pressed the script will be called, I hope.
I have been toying with Approach(97) recently and I wanted to add a script call to a macro and although this is supposed to be possible using macro command 'run' the scripts I have written do not seem visible to this option.
I have to concur with Dale that the Lotusscript environment is very hard to get into as a casual user and I have concluded that I will have to buy a book or some other drastic action. This is a bit annoying when all I wanted to do was to change the background colour of a rectangle on a form dependant upon some value on the form. I found it very hard to work out intuitively how to refer to form objects and the help was not that helpful. Whenever I write a script and attempt to run a script from the editor the message Cannot Run this ???? is displayed whether there are any errors or not? Oh well I have a learning curve to try and surmount speak to you guys soon.
Regards Pete
- Status
Similar threads
- Locked
- Question
- Locked
- Question