AutoMacro: Download & Troubleshooting

VBA Code Examples
companies

AutoMacro has been used by employees of these organizations. These organizations do not endorse, approve, sponsor, or otherwise have any affiliation with this website, Spreadsheet Boot Camp LLC, or ToolFive Software LLC.

Walkthrough

See the complete walkthrough of AutoMacro here.

Download

Below you will find two download links for the 64-bit and 32-bit versions of AutoMacro. You need to download the version of AutoMacro 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.

Installation

Install

To install the file, simply click the download link above. Then click the AutoMacro downloaded file in your browser (see image below) or navigate to your download folder and double-click the MSI file.

You may see a warning message. This is a standard Windows warning message that appears when trying to install software from smaller software publishers. You can ignore it and click "run" or "install". If you are running Windows 10 (or possibly other versions), you may need to click "show more" before the "run" option appears.

Enable / Disable

Once you install the add-in, you can easily enable or disable it from the Visual Basic Editor (VBE).

1. Open the VBE

You can use the shortcut ALT + F11 to open the VBE or navigate to the Developer Ribbon Tab and click "Visual Basic" (If you don't see the Developer Ribbon Tab follow these directions).

1. Open the Add-in Manager from the VBE Toolbar

2. Select the AutoMacro add-in and choose your desired settings.

If 'Loaded/Unloaded' is checked, the add-in is active. If you uncheck it, then the add-in is disabled. If 'Load on Startup' is selected, then the add-in will automatically load on startup. For the add-in to function properly, make sure both checkboxes are checked.

Uninstall

It's easy to completely uninstall AutoMacro from your computer.

1. Go to Windows > Control Panel

2. Go to 'Uninstall a Program'

3. Find 'AutoMacro', right-click on it, and choose uninstall.

Troubleshooting

Activation Not Working?

A small percentage of users encounter an issue when attempting to activate AutoMacro. AutoMacro says the activation is successful, but nothing is unlocked:

activation failed

This is caused by a date formatting issue in your Windows settings.  You can manually fix the problem by following these steps:

  1. Go to Control Panel > Region and then select Short Date as (MM/dd/yyyy).
  2. Click Additional Settings (at the bottom of the same window).
  3. Click Date (the last tab). Then change the year to 9999 in the Calendar section (See below)
AutoMacro date format

If you try fixing these settings and still experience issues, please contact support@toolfivesoftware.com and we will provide you with another workaround.

32-bit vs. 64-bit Version:

If you install the wrong version of the add-in, you will see a message "unable to load add-in". Remember, you must install the version that corresponds to your Microsoft Office/Excel installation, NOT your Windows installation.

If you're experiencing any other issues follow these steps:

1. Unload the add-in and then reload it (See section "Enable / Disable" above)

2. Close and restart Excel

3. Email support@toolfivesoftware.com

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

AutoMacro Features

Code Library

200+ Ready-to-use code examples.

 

Save your own frequently used code and share with team members.

vba code library builder
vba code tools

Coding Tools

VBA Coding tools to improve the out of date Visual Basic Editor.

Speed up your workflow with tools to navigate, debug, format and more.

Code Generators

Code Generators build code from scratch via visual interfaces.

No coding knowledge required!

vba code tools

Why Wait? Order Now

Beginner

Simple version for beginners

Lifetime license valid for 1 computer*

Interactive VBA Tutorial
100 ready-to-use code examples
Procedure Builder
All other code generators
Coding tools
Create your own code library
Excel / VBA Model Debugger

$79 $59

*Single-use license code valid for 1 computer (life-time access)

Upgrade Anytime!

Developer

Tools for serious developers

Lifetime license valid for 3 computers*

Interactive VBA Tutorial
230+ ready-to-use code examples
Procedure Builder
All other code generators
Coding tools
Create your own code library
Excel / VBA Model Debugger

$159 $139

*Single-use license code valid for 3 computers (life-time access)

Upgrade Anytime!

Customer Reviews

FAQ and Other Information

FAQ

What is your refund policy?

We have a 30-day, no-questions-asked, 100% money-back guarantee. If you’re unsatisfied for any reason, let us know and we will refund your order!

Can I try AutoMacro before I buy?

Yes! You can download AutoMacro here: https://www.automateexcel.com/automacro/download-walkthrough2. Most of the features are disabled until you enter a License Code, but you can verify that it works properly on your computer. If for some reason it doesn't install properly, let us know: support@toolfivesoftware.com.

Can I install AutoMacro on my work computer?

Yes! 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 was designed to work on all Microsoft Windows systems (7,8,10, etc. and 32-bit or 64-bit). It will also work on all versions of Microsoft Office (2007, 2010, 2013, 2016), including 64-bit Microsoft Office. Try the download link above to make sure!

Will my company pay for AutoMacro?

Your company may have an allowance that will reimburse you for productivity tools like AutoMacro. This is the case for some of our users. Ask your boss, HR, or IT!

Can I deduct this purchase on my taxes?

See this page from the IRS on Employee Business Expenses.

Can I use on more than one computer?

The Beginner version entitles you to a single-use license code valid for 1 computer. The Professional version entitles you to a single-use license code valid for 2 computers for which you are the primary user. The Developer version is valid for 3 computers.

Does AutoMacro work with PowerPoint, Word, or Access?

Yes! AutoMacro functions in any program with the Visual Basic Editor. The code fragments are (currently) intended for Excel, but all features will work in any Visual Basic Editor environment.

Code Library

VBA Code Library: Easy access to 230+ ready-to-use code fragments and the ability to create your own code library.

Save Your Own Code

Create your own code library. Organize into folders. Share with colleagues.
Learn More

Settings

Toggle the most-used Excel / VBA settings.
Learn More

Keyboard Shortcuts

All code accessible via keyboard shortcuts. Simply look at underlined letters.
Learn More

Files

Code for working with files and folders.
Learn More

Objects

Toggle the most-used Excel / VBA settings.
Learn More

Much More!

Ifs, Case Selects, Loops, Fors, MessageBoxes, Text, Dates, Times, and ready-to-use functions.
Learn More

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

  • Comment / Uncomment multiple lines
  • Code indenter
  • Remove excess blank lines

Learn More

Navigation Tools

  • Back / Forward Buttons
  • Create bookmarks and goto with shortcut keys
  • Close all windows

Learn More

Debug Excel Model

  • Review all ranges used in VBA. Identify problems.
  • List all procedures, code, and where used.
  • Scan for formula errors
  • & more

Learn More

Misc. Utilities

  • Sort code
  • Show line numbers
  • Mass import / export of code modules
  • Copy & Paste UserForm controls & their code

Learn More

Code Generator

VBA code generators build code from scratch with visual interfaces.
Minimal coding knowledge required.

Loop Builder

Build code to loop through objects, performing actions when certain criteria are met.
Learn More

Array Builder

Create arrays, collections, and dictionaries from scratch and quickly manipulate them..
Learn More

MessageBox Builder 

Create professional looking MessageBoxes and Inputboxes with an easy to use visual interface.
Learn More

Procedure Builder

Create VBA procedures with your desired settings. Great for Beginners who don't know what settings can be used in procedures!
Learn More

File Builder

Generate procedures to loop through files in a folder, performing actions on files that meet certain criteria. Great for merging together multiple files.
Learn More

Format Builder

Quickly create a preview number formats in VBA.
Learn More

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 - United Kingdom

Steve Rynearson:
Creator of AutoMacro

Over the years, I've spent countless hours searching online for example code and adapting that code to my needs.

I often found myself clicking the same links and copying the same code. I thought there has to be a better way!

AutoMacro eliminates much of this need to search online for code. Instead simply use the menus to select pre-built code or use the builders to generate code for your exact needs.

Additionally, the coding tools will save you time and help you develop more professional looking code.

For anyone coding VBA, AutoMacro is a life-saver. You'll code much faster, develop more professional code, and learn VBA much faster (if you're not already an expert).

steve
signature