MacroRunner for Excel Free Download
MacroRunner for Excel
MacroRunner for Excel Free Download.
MacroRunner is a powerful Excel add-in that enables users to easily automate the process of running Excel macros. MacroRunner provides two methods for automation.
One method involves the addition of a user defined function called RunMacro which can be inserted into a worksheet. The RunMacro function works by allowing you to run macros in response to whether a specified condition evaluates to true or false.
The second method allows you to run macros in response to several workbook and worksheet related events. With MacroRunner you can take control of when your Excel macros run with no programming involved.
As mentioned above, the RunMacro function allows you to run macros based on whether a condition that you specify evaluates to true for false.
The condition consists of comparing two values with a comparision operator (e.g. A1 > 5). You have a number of different options to choose from for each of the two values including a single cell range, a number value, text value, or a value that is returned from another function.
You also have several different comparison operator options to choose from including "Begins With" which allows you to specify what set of characters the first value should begin with (e.g A1 Begins With "Bac") . You have the option of running one macro if the condition evaluates to true and another macro if the condition evaluates to false.
In addition to running macros, you can specify that the function returns a value depending on whether the condition evaluates to true or false.
The second method for automating macros is to assign a macro to run in response to an Excel related event.
MacroRunner provides several events to choose from including when the workbook first opens. when the workbook closes, when a particular sheet is first activated, and when a particular sheet is deactivated by clicking on it.
MacroRunner for Excel keywords: excel, macro, automate, run, add-in, excel add-in, excel formula, excel macro, formula
Excel VBA and Excel UserForms Training
All information within these lessons are drawn from 'real world' experience and not fictitious class room scenarios. There are five Workbook examples with the 20 lessons
Data Manager for Excel
Data Manager is an Excel add-in that allows you to convert worksheets into tables, conduct queries, and create forms. Using buttons that can be added to your forms, you can open forms, run macros, open hyperlinks, and send data to Microsoft Word.
Consolidate Excel forms without selecting a cell! Look at the total and immediately see the breakdown of each cell without moving between sheets. ConsoXL consolidates multiple workbooks and sheets of different formats at once.
4TOPS Compare Excel Files
This easy to use program that clearly reports where and what the differences are. Features: -differences in HTML Analysis report and Visualization reports are hyperlinked -Can be used as part of an automated process using API (ActiveX
JExcel library enables easy integration of Microsoft Excel into Swing applications and allows to work with Excel workbooks and worksheets from Java programs.