AutoMacro
Write Better Code, Faster & Easier
What is AutoMacro?
AutoMacro:
- Is an add-in for VBA.
- Installs directly into the Visual Basic Editor (VBE).
Depending on the version, AutoMacro comes loaded with:
- Code generators;
- An extensive code library;
- The ability to create your own code library; and
- Many other helpful time-saving tools and utilities.
AutoMacro doesn't need to be installed on a computer for the generated code to run. Once the code is generated, anyone can use it!
Join the Hundreds of Professionals Who Use AutoMacro
"Support is 5 star
So far the product is intuitive and comprehensive
Documentation and templates are really good
I wish I had found it 10 years ago"
Len G. - Australia
Code Builders
- Generate VBA code from scratch
- Visual Interface "Code Helpers"
Code Library
- Hundreds of ready-to-use code examples
- Save your own code
Coding Tools
- Tools for Formatting and Navigating
- Excel Model Debugger & More
VBA Code Generators - Create VBA Code From Scratch
AutoMacro's VBA Code Generators build code from scratch via visual interfaces. No coding knowledge required!
Loops
Build code to loop through objects, performing actions when criteria are met.
Message Boxes
Create professional looking MessageBoxes and InputBoxes with an easy-to-use visual interface.
Copy Paste
Intuitively build code to copy (or cut) and paste across any worksheet in any open workbook, including paste special operations.
Arrays
Create Arrays, Collections, and Dictionaries from scratch.
Quick access buttons can be used to quickly insert code for common actions.
Files
Generate procedures to loop through files in a folder, performing actions on files that meet certain criteria.
Great for merging together multiple files!
Class and Property Builders
Easily create classes and properties - Eliminate repetitive coding.
Procedures
Create procedures with desired settings.
Great for beginners who don't know what settings can be used in procedures!
Formats
Create and preview number formats.
UserForms
Quickly create UserForms with consistent spacing and pre-generated code.
Join the Hundreds of Professionals Who Use AutoMacro
"I use it almost every day. A great tool for getting things done, but also a great tool for learning how to do things! This is one purchase this year I have no regrets about."
Galen - USA
Code Builders
- Generate VBA code from scratch
- Visual Interface "Code Helpers"
Code Library
- Hundreds of ready-to-use code examples
- Save your own code
Coding Tools
- Tools for Formatting and Navigating
- Excel Model Debugger & More
Code Library
AutoMacro’s code library contains hundreds of commonly used code fragments for Excel, Access, Outlook, Word, and PowerPoint. As well as the ability to add your own code to the library.
Simply select the code from AutoMacro’s menu and it will be inserted directly into your module.
Object Code Library
Easily manipulate objects like Ranges, Columns, Rows, Sheets, and Workbooks. Great for Beginners!
Settings
The Settings library contains the most common Excel / VBA settings that you will use.
Great as a reference to see what settings are available!
Files
Code for working with files and folders.
Custom Code Library
Create your own VBA Code Library. Organize code into folders and access all code via keyboard shortcuts.
Share custom code folders with co-workers.
Join the Hundreds of Professionals Who Use AutoMacro
"I have only just scratched the surface of what's doable AutoMacro, and already I'm blown away! This is definitely money well spent for anyone who works with VBA regularly."
Jody L.
Code Builders
- Generate VBA code from scratch
- Visual Interface "Code Helpers"
Code Library
- Hundreds of ready-to-use code examples
- Save your own code
Coding Tools
- Tools for Formatting and Navigating
- Excel Model Debugger & More
VBA Code Tools
AutoMacro’s Coding Tools and Utilities make coding in VBA easier. Use the tools to navigate, edit, format, and debug your code.
Formatting Tools
Tools to format VBA Code:
- Comment / Uncomment multiple lines
- Code indenter
- Remove excess blank lines
Navigation Tools
Tools to navigate VBA:
- Back / Forward Buttons
- Create bookmarks and GoTos with shortcut keys
- Close all windows
- Close all windows except active
Miscellaneous Utilities
- Sort code
- Show line numbers
- Mass import / export of code modules
- Copy & Paste UserForm controls & their code
Excel/VBA Model Debugger
- Check for hard-coded ranges in VBA
- See all procedure contents
- List named ranges and shapes
- Find Excel errors
Why Wait? Get AutoMacro Now!
BEGINNER
1 User
1 PC
One-time fee
Upgrade Anytime!
DEVELOPER
1 User
3 PCs
One-time fee
Upgrade Anytime!
DEVELOPER+
1 User
3 Transferable PCs & Updates
One-time fee + Annual subscription
Join the Hundreds of Professionals Who Use AutoMacro
"I am a seasoned developer but I use this utility daily. If you are not at the developer level, this tool will help you become a good developer. If you ARE at the developer level, this tool will keep your coding habits proper! I LOVE it. Thanks!"
William W. - USA
FAQ
Here are answers to some frequently asked questions
AutoMacro works in many corporate environments. It was designed to be as unobtrusive as possible and should install without the need for "admin privileges".
AutoMacro is compatible with all versions of Microsoft Office for PCs.
- 32-bit or 64-bit
- Office 2003, 2007, 2010, 2013, 2016, 2019, 2021, and Office 365.
- All Versions of Windows.
- Surface Pro.
AutoMacro is not compatible with Mac operating systems. Some Mac users running Windows OS are able to use AutoMacro.
AutoMacro is not compatible with Citrix environments.
Depends on your version of AutoMacro.
- AutoMacro Beginner entitles you to a single-use license code valid for 1 computer.
- AutoMacro Developer is valid for 3 computers.
- AutoMacro Developer+ allows you to transfer activations between PCs, so that AutoMacro can be activated on any 3 PCs at one time.
Yes! AutoMacro works with any program with the Visual Basic Editor.
AutoMacro's Code Library contains hundreds of commonly used code fragments for Excel, PowerPoint, Word, Outlook, and Access.
If you have questions about AutoMacro, please contact me:
- By replying to any of the emails I send you (if you're already part of the Power Spreadsheets Newsletter); or
- Through the Contact Form here.
I do my best to answer your question(s) within 1 business day.
Join the Hundreds of Professionals Who Use AutoMacro