MacroRunner for Excel 1.0

许可: 免费试用 ‎文件大小: 196.13 KB
‎用户评分: 4.0/5 - ‎1 ‎评分

MacroRunner 是一个功能强大的 Excel 外接程序,使用户能够轻松地自动执行运行 Excel 宏的过程。MacroRunner 提供了两种自动化方法。一种方法涉及添加名为 RunMacro 的用户定义的函数,该函数可以插入到工作表中。RunMacro 函数的工作原理是允许您运行宏,以响应指定条件是计算为 true 还是 false。第二种方法允许您运行宏以响应多个工作簿和工作表相关的事件。 使用 MacroRunner,您可以控制 Excel 宏何时运行,无需编程。 如上所述,RunMacro 函数允许您根据指定的条件是否计算为 false 为 false 来运行宏。该条件包括将两个值与比较运算符进行比较(例如 A1 > 5)。对于两个值中,每个值都有许多不同的选项可供选择,包括单个单元格范围、数字值、文本值或从另一个函数返回的值。您还可以选择几个不同的比较运算符选项,包括"开始",它允许您指定第一个值应以什么字符集开头(例如 A1 以"Bac"开头)。如果条件计算为 true,您可以选择运行一个宏;如果条件计算为 false,您可以选择运行另一个宏。除了运行宏外,还可以指定函数返回一个值,具体取决于条件是计算为 true 还是 false。 自动化宏的第二个方法是分配一个宏以响应 Excel 相关事件。MacroRunner 提供了多个事件可供选择,包括工作簿首次打开时。当工作簿关闭时,当首次激活特定工作表时,以及单击另一个工作表停用特定工作表时。

版本历史记录

  • 版本 1.0 发布于 2007-03-01

软件信息

终端用户许可协议

MACRORUNNER - PRODUCT LICENSE INFORMATION NOTICE TO USERS: CAREFULLY READ THE FOLLOWING LEGAL AGREEMENT. USE OF THE SOFTWARE PROVIDED WITH THIS AGREEMENT (THE "SOFTWARE") CONSTITUTES YOUR ACCEPTANCE OF THESE TERMS. IF YOU DO NOT AGREE TO THE TERMS OF THIS AGREEMENT, DO NOT INSTALL AND/OR USE THIS SOFTWARE. USER'S USE OF THIS SOFTWARE IS CONDITIONED UPON COMPLIANCE BY USER WITH THE TERMS OF THIS AGREEMENT. 1. LICENSE GRANT. Datasoft Solutions grants you a license to use one copy of the version of this SOFTWARE on any one system for as many licenses as you purchase. "You" means the company, entity or individual whose funds are used to pay the license fee. "Use" means storing, loading, installing, executing or displaying the SOFTWARE. You may not modify the SOFTWARE or disable any licensing or control features of the SOFTWARE except as an intended part of the SOFTWARE's programming features. When you first obtain a copy of the SOFTWARE, you are granted an evaluation period of not more than 14 days, after which time you must pay for the SOFTWARE according to the terms and prices discussed in the SOFTWARE's documentation, or you must remove the SOFTWARE from your system. This license is not transferable to any other system, or to another organization or individual. You are expected to use the SOFTWARE on your system and to thoroughly evaluate its usefulness and functionality before making a purchase. This "try before you buy" approach is the ultimate guarantee that the SOFTWARE will perform to your satisfaction; therefore, you understand and agree that there is no refund policy for any purchase of the SOFTWARE. 2. OWNERSHIP. The SOFTWARE is owned and copyrighted by Datasoft Solutions. Your license confers no title or ownership in the SOFTWARE and should not be construed as a sale of any right in the SOFTWARE . 3. COPYRIGHT. The SOFTWARE is protected by United States copyright law and international treaty provisions. You acknowledge that no title to the intellectual property in the SOFTWARE is transferred to you. You further acknowledge that title and full ownership rights to the SOFTWARE will remain the exclusive property of Datasoft Solutions and you will not acquire any rights to the SOFTWARE except as expressly set forth in this license. You agree that any copies of the SOFTWARE will contain the same proprietary notices which appear on and in the SOFTWARE. 4. REVERSE ENGINEERING. You agree that you will not attempt to reverse compile, modify, translate, or disassemble the SOFTWARE in whole or in part. 5. NO OTHER WARRANTIES. DATASOFT SOLUTIONS DOES NOT WARRANT THAT THE SOFTWARE IS ERROR FREE. DATASOFT SOLUTIONS DISCLAIMS ALL OTHER WARRANTIES WITH RESPECT TO THE SOFTWARE, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES OR LIMITATIONS ON HOW LONG AN IMPLIED WARRANTY MAY LAST, OR THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THE ABOVE LIMITATIONS OR EXCLUSIONS MAY NOT APPLY TO YOU. THIS WARRANTY GIVES YOU SPECIFIC LEGAL RIGHTS AND YOU MAY ALSO HAVE OTHER RIGHTS WHICH VARY FROM JURISDICTION TO JURISDICTION. 6. SEVERABILITY. In the event of invalidity of any provision of this license, the parties agree that such invalidity shall not affect the validity of the remaining portions of this license. 7. NO LIABILITY FOR CONSEQUENTIAL DAMAGES. IN NO EVENT SHALL DATASOFT SOLUTIONS OR ITS SUPPLIERS BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, SPECIAL, INCIDENTAL OR INDIRECT DAMAGES OF ANY KIND ARISING OUT OF THE DELIVERY, PERFORMANCE OR USE OF THE SOFTWARE, EVEN IF DATASOFT SOLUTIONS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN NO EVENT WILL DATASOFT SOLUTIONS' LIABILITY FOR ANY CLAIM, WHETHER IN CONTRACT, TORT OR ANY OTHER THEORY OF LIABILITY, EXCEED THE LICENSE FEE PAID BY YOU, IF ANY. 8. GOVERNING LAW. This license will be governed by the laws of the State of Florida as they are applied to agreements between Florida residents entered into and to be performed entirely within Florida. The United Nations Convention on Contracts for the International Sale of Goods is specifically disclaimed. 9. ENTIRE AGREEMENT. This is the entire agreement between you and Datasoft Solutions which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license.