AutoMacro – Download, Install, Troubleshooting, and Walkthrough

AutoMacro - Download, Install, and Walkthrough

vba code writer

New Release Available!:   The new Developer version of AutoMacro is now available. Please use the download links below to access the new version!

We'll roll out video walkthroughs for AutoMacro over the next week.

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.

If you install the wrong version, you will receive a "Add-in can not be loaded" error message when attempting to open VBA. If you see this message, uninstall the add-in (see directions below) and download/install the other version.

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

Walkthrough

Open a Module

AutoMacro inserts code directly into the active module. If no module is open, you will receive this error:

To create a module:


Walkthrough

Procedure Builder

With the Procedure Builder you can easily create procedures (with your desired settings) from scratch.

ALT + P

The 'Save Settings as Default' button allows you to save the current settings for future use.

Experienced users may find it saves time to use the interface rather than manually code each potential option.

Beginners should use the Procedure Builder to learn what options can (and should) be used when creating procedures. Unhide below to see a description of all the options:

Procedure Builder Options


Object Builder and Other Code Fragments

In VBA, objects are "things" to which you can apply methods or properties. In Excel the most common objects are ranges (cells), sheets, workbooks, and rows / columns. The Object Builder allows you to easily work with these common objects.  If you are new to VBA the Object Builder should be the most useful feature of AutoMacro.
 

Objects can "contain" other objects. The Range object is contained within a Sheet (or Worksheet) object. The Sheet object is contained within a Workbook object.  If you reference a Range object without specifying a Sheet object, VBA assumes you mean the ActiveSheet. If you reference a Sheet object without specifying a Workbook object, VBA assumes you mean the ActiveWorkbook.

The Object Builder allows you to reference a Range object by itself (so ActiveSheet is assumed) or within a Sheet or Workbook+Sheet:

By default, the Object Builder (and all other code) will generate code that references the currently active Range, Worksheet, Workbook, or Row/Column when generating the code:

Instead you can tell AutoMacro to use an Object Variable instead (note: Not familiar with object variables? Learn about them with our free interactive VBA tutorial):

To change this setting, check the "Insert Object Variables" checkbox in the Settings (not the Settings menu drop-down, but the second to last button in the menu).

The default variable names are wb, ws, and rng, but you can define custom Variable Names if you would like.

These settings work with all of AutoMacro's code.

The setting also works with any Custom Code that you create when you use the dummy values found in column 'Object Name' in the table above.


Custom Code

You can save your own custom code fragments in the Custom Code menu.
 

1. Highlight the desired code

2. Navigate to 'Custom Code' and click 'Add Code' (or right-click and click 'Add Code' - not shown)

3. Name your code fragment and click 'Save'

4. You will find your code fragment in the 'Custom Code' menu. Like everything else in AutoMacro, you can access the code fragment with the alt accelerator keyboard shortcuts (ex. Alt > C > N > E below)

AutoMacro stores these custom code fragments in a directory on your hard drive. The directory location can be changed in the Settings (not the Settings menu drop-down, but the second to last button in the menu).

Misc Notes:

- Some teams set up a shared 'Custom Code' folder on their network to share files between team members.

- The 'Custom Code' Folder contents will not move if you change directories. You will need to manually copy & paste the desired files if you change directories.

- You can add folders to the directory and those folders will appear in the 'Custom Code' drop-down (see above example). 

- The first letter of each file name is used for the alt accelerator shortcuts.


Comment / Uncomment Lines of Code

You can easily comment-out multiple lines of code at once with the shortcut CTRL + ALT + C, from the menu button, or within the right-click menu. AutoMacro is smart enough to handle (and clean up) scenarios like indented apostrophes, inconsistent line commenting, etc.

CTRL  + ALT + C

Also accessible from the right-click menu:


Settings

The 'Settings' menu button allows you to change two settings:

1. The 'Custom Code' folder location (discussed in 'Custom Code' section above)

2. Toggle between using the Active Range, Sheet, or Workbook or corresponding object variable names when inserting code. (discussed in 'Object Builder' section above)
 


Help

Clicking the 'Help' button allows you to see important information regarding your subscription:

Notice the 'Check for Updates' button. Currently, AutoMacro does not automatically check for updates. Clicking this button is the only way to make sure you have the latest version.

The Help section contains useful links. Notice the 'Feedback, Suggestions, and Requests' section. We created the subreddit /r/automateexcel for you to discuss this add-in with us and other users. This is the best way to make requests or to provide any other feedback because you can discuss with other users.  Hopefully, users will share their favorite custom code fragments here and we can incorporate them into future versions.


Shortcuts

Create Bookmarks with the shortcut CTRL + ~
- Bookmarks allow you to record a code location and easily return to it later.

CTRL  + ~

Jump to the next (previous) Bookmark with CTRL + 1 (CTRL + 2)

CTRL  + 1

Comment / Uncomment Multiple Lines of Code at Once

You can easily comment-out multiple lines of code at once with the shortcut CTRL + ALT + C, from the menu button, or within the right-click menu. AutoMacro is smart enough to handle (and clean up) scenarios like indented apostrophes, inconsistent line commenting, etc.

CTRL  + ALT + C

Virtually Every Other Feature in AutoMacro is accessible via Alt Shortcuts

To activate any menu option, tap ALT then tap the underlined letter corresponding to the item you want. If two items have the same underlined letter, you may need to press the letter key again to activate the item you want.

ALT > C > N > E

VBA Tutorial

Do you need to learn VBA from scratch?  Are you an experienced VBA user looking to learn some new tricks?

Check out our completely free interactive VBA tutorial!

vba tutorial