AutoMacro
Write Better Code, Faster & Easier

This sale is live for a limited time only

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!

AutoMacro is an add-in for VBA

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.

Build VBA code that loops through objects/items.
Create Message and Input Boxes

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.

Build code to copy or cut and paste across any worksheet
Create arrays, collections and dictionaries from scratch

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!

Build VBA code to work with all files in a folder
Create classes and properties

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!

Create procedures with desired settings
Create and preview number formats

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!

Easily manipulate objects
The Settings library contains the most common Excel/VBA settings

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.

Code library 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
Tools to format VBA code
Tools to navigate VBA code

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
Sort code, show line numbers, import/export modules, copy/paste UserFrom controls/code
Debug Tool makes reviewing Excel models easier

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!

This sale is live for a limited time only

BEGINNER

1 User

1 PC

  • Interactive VBA Tutorial
  • 100+ ready-to-use code examples
  • Procedure, Loops, & Copy Paste Builders

One-time fee

AutoMacro money back guaranteed

Upgrade Anytime!

DEVELOPER+

1 User

3 Transferable PCs & Updates

  • Interactive VBA Tutorial
  • Hundreds of ready-to-use code examples
  • Procedure, Loops, & Copy Paste Builders
  • All other code generators
  • Coding tools
  • Create your own code library
  • Transfer activations to other PCs
  • Access to new features & updates

Currently on sale!

One-time fee + Annual subscription

AutoMacro money back guaranteed

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

What is the refund policy for AutoMacro?

AutoMacro has a 30-day, no-questions-asked, 100% money-back guarantee.


If you’re unsatisfied for any reason, please email (within the 30 days immediately following your purchase) Steve (the creator of AutoMacro) and his team at support@toolfivesoftware.com to let them know you want a refund.

Can I install AutoMacro on my work computer?

AutoMacro works in many corporate environments. It was designed to be as unobtrusive as possible and should install without the need for "admin privileges".

Will AutoMacro work on my system?

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.

Can I use AutoMacro on more than one computer?

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.

Does AutoMacro work with PowerPoint, Word, Outlook, or Access?

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.

What do I do if I need help or have more questions?

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

"Great product, haven’t stopped using it since I purchased it. It doesn’t just write your code, it teaches as you go!"

Tony D. - UK