web site counter

MacroRunner - Automate your Excel Macros

Forms used to update and add records to your database
Click here to enlarge

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.

RunMacro Function

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.

Running a Macro in Response to an Event

The second method for automating macros is to assign a macro to run in response to an Excel related event. MacroRunner gives several events to choose from including:

  • when the workbook first opens
  • when the workbook closes
  • when a particular sheet is first activated
  • when a particular sheet is deactivated by clicking on it

You can assign more than one macro to an event and the same macro to multiple events.

Consulting Services

Should you need a customized macro or any other Excel VBA development work done, we would be happy to review you requirements and provide you with a low cost estimate. To learn more click here or contact us by e-mail