Test Translation – File Processor

File Processor The File Processor makes it easy to manipulate Excel files or non-Excel files. It is found here in the VBA Editor: And here in the Excel Ribbon: 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 –…

Read More

Excel vs. VBA

AutoMacro is available for the VBA Editor: And in the Excel Ribbon: These require two separate installers to access the software. The downloads are found here. AutoMacro for Excel AutoMacro for Excel is perfect for inserting Macros into your Excel workbook. Conveniently found in the Excel Ribbon, AutoMacro can insert or run Macros with just…

Read More

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 for VBA 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 64-Bit Note:…

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. It can be found in it’s own toolbar in the VBA Editor: Or in the Excel Ribbon: 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:…

Read More

File Processor The File Processor makes it easy to manipulate Excel files or non-Excel files. It is found here in the VBA Editor: And here in the Excel Ribbon: 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 –…

Read More