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
軟體細節
- 軟體分類: 業務 > 其他
- 發佈者: Datasoft Solutions
- 軟體性質: 免費試用
- 價格: $9.95
- 版本: 1.0
- 作業系統: windows
終端使用者許可協定
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.