Settings

AutoMacro’s settings can be adjusted by clicking this button: Objects When inserting code with references to objects (Ranges, Worksheets, Workbooks, etc.). AutoMacro can do one of two things with the object references: To use variable names, make sure the Insert Object Variables box is checked. Then you can rename the default variables: Show / Hide…

Read More

Interactive VBA Tutorial

AutoMacro contains an interactive VBA tutorial. Allowing you to learn VBA inside the VBA Editor. Receive real-time feedback as you complete each exercise.

Read More

AutoMacro Download / Getting Started

Online Access Click here to access our online AI tools. Download AutoMacro Important! You need to download the software version that matches your Microsoft Office installation (Not your Windows Installation!). To check which version you have installed, follow these directions.  If you install the wrong version, the add-in will not work. Download 32-Bit Download 64-Bit If…

Read More

Code Library

AutoMacro’s Code Library contains hundreds of professionally developed code examples that can be inserted with a simple mouse click: The menus are found here: You can add your own code to the library here: Code For Excel The Excel code library the following code menus (and more): Objects The Objects menu is where you’ll find…

Read More

Loop Builder

The Loop Macro Builder is the most flexible and powerful automation tool in AutoMacro. Loop Macros repeat action(s) on all items of a certain type, or all items of a certain type that meet certain rules. Use Cases: Like all AutoMacro’s Macros, Loop Macros can be used in the following ways: AutoMacro allows you to…

Read More

The File Processor makes it easy to manipulate Excel files or non-Excel files. Simply select the folder(s) to process, create rules to determine which files are processed, and select what action to perform on those files. Merge Files – Match Header The Merge Files features allow you to merge data from multiple files into one…

Read More

Class & Property Builders

The Class and Property Builders make it easier to create and use properties in classes in VBA. Class Builder The Class Builder creates a Class Module with specified properties. To use the Class Builder you only need to enter two things: Clicking the “Create” button adds the class: Property Builder The property builder will add…

Read More

Procedure Builder

The Procedure Builder (ALT + P) quickly generates a procedure with specific settings (ScreenUpdating, etc.). You can save your default procedure settings to save time when writing new procedures. Output: Use Cases Save Settings as Default To save your current settings as default (for easy access in the future), click the bottom in the bottom-right…

Read More