Home

 

AutoMacro: Upgrades

vba object insert code
Features Experienced VBA Users will love:

Differences Between the Tiers

Beginner

Life-time license valid for 1 computer*

Code Library

  • check
    Settings (12 options)
  • check
    Objects (limited options)
  • check
     Ifs, Loops, and Messageboxes
  • check
    Fxs
  • check
    Text
  • check
    DateTime
  • check
    Files

Other Features

  • check
    All time-saving features and shortcuts
  • check
    Create your own code library
  • check
    MessageBox & Format Builders
  • check
    File Processing Wizard
  • check
    Loops Builder

Standard

Life-time license valid for 2 computers*

Code Library

  • check
    Settings (33 options)
  • check
    Objects (all options)
  • check
     Ifs, Loops, and Messageboxes
  • check
    Fxs
  • check
    Text
  • check
    DateTime
  • check
    Files

Other Features

  • check
    All time-saving features and shortcuts
  • check
    Create your own code library
  • check
    MessageBox & Format Builders
  • check
    File Processing Wizard
  • check
    Loops Builder

Professional

Life-time license valid for 3 computers*

Code Library

  • check
    Settings (33 options)
  • check
    Objects (all options)
  • check
     Ifs, Loops, and Messageboxes
  • check
    Fxs
  • check
    Text
  • check
    DateTime
  • check
    Files

Other Features

  • check
    All time-saving features and shortcuts
  • check
    Create your own code library
  • check
    MessageBox & Format Builders
  • check
    File Processing Wizard
  • check
    Loops Builder

Standard Upgrade Features

Functions

  • Does a specific Sheet & Range exist? TRUE / FALSE
  • Does a file exist? TRUE / FALSE
  • Standard start & end procedure declarations

Text, Dates, and Times

  • VBA comes with many tools for working with text, dates, and times.
  • AutoMacro provides examples for you to reference

Save Your Own Frequently Used Code:

Do you find yourself using similar code over and over again across multiple workbooks?  If so, you can save your own code to the custom code folder and easily access it whenever you want!  It's easy:

1. Highlight the Desired Code

vba code sample

3. Name your code fragment and click 'Save'

save vba code example

2. Navigate to 'Custom Code' and click 'Add Code'

vba add code sample

4. Click your code fragment and insert it into your module. Or... Better yet, use the "Alt Accelerator" keyboard shortcut to insert saved code with just a few keystrokes.

insert code sample code

Professional Upgrade Features

Files

  • Functions to work with files: Does a file exist?, Get file name from path, and unzip files.
  • The Files menu contains code to manipulate files
  • The Folders menu contains code to work with folders
  • SpecialFolders provides code to access MyDocuments and other special folders
  • The TextFiles menu contains code to work with text files allowing you to load them into VBA's memory, edit them, and more.

Code Builders

Loops Builder

vba loops builder

The Loops Builder makes it easy to design code to loop through objects, numbers, and arrays:

  • ​Loop Through
    • Cells, Sheets, and Workbooks
    • Shapes: Charts, PivotTables, & More
    • Numbers
    • Arrays
  • Perform actions on the objects:
    • Set Value
    • Rename
    • Delete
    • Hide
    • & Much More
  • Set Criteria - Only perform actions on objects that meet specified criteria. Also perform different actions on different objects based on criteria.

The Loops Builder is the perfect tool for any VBA programmer looking to save time when creating powerful loops. This feature is especially useful for beginners!

File Processing Wizard

The File Wizard allows you to generate ready-to-use procedures to:

  • Loop through all the files in a  folder (or folders)
  • Select files that meet certain criteria
    • All Files
    • All Excel Files
    • All Excel + CSV Files
    • File name matches (starts with, ends with, contains, etc.)
  • Perform an action on those files:
    • List
    • Copy
    • Move
    • Open
    • Merge

The File Wizard makes it incredibly easy to process large numbers of files at once. Simply enter the criteria into the File Wizard and run the generated code!

MessageBox Builder

The MessageBox Builder allows you to easily create professional looking MessageBox and InputBox prompts.

Simply enter the title and text. Then select your desired icon, buttons, and default button.

You will see a preview of the messagebox and the corresponding code.

Once it looks good, insert the code, and enter the actions to perform based on the user's selection within the Select Case code.

The InputBox tab works the same way, except you will be able to define a default value, and an input type.

Procedure Builder

The Procedure Builder allows you to create procedures with specific application settings, error handling, and more.

Beginners will find this useful to understand what options are available when creating procedures. Advanced users may find it to be a big time saver.

The Procedure Builder also encourages coding "best practices", prompting you to disable ScreenUpdating, Automatic Calculations, handle errors, display a MessageBox after completion, and more.

File Processing Wizard

The Format Builder makes it easy to format numbers in VBA.

Simply enter your value then choose between a default format, commonly used custom format, or enter your own custom format.

You will see a preview of the formatted value and once you verify the format is correct, you can insert the code.

No more trial and error while you try to find the correct format!

vba object insert code
AutoMacro - The easiest way to create VBA code.

Why Wait? Order now

Standard

For casual VBA users


Life-time license valid for 2 computers*

  • check
    Procedure Builder
  • check
    All Time-saving tools and shortcuts
  • check
    200 ready-to-use code Fragments
  • check
    Create your own code library
  • check
    MessageBox & Format Builders
  • check
    File Processing & Loops Wizards

$30

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

         Upgrade anytime

Professional

All Features


Life-time license valid for 3 computers*

  • check
    Procedure Builder
  • check
    All Time-saving tools and shortcuts
  • check
    230 ready-to-use code Fragments
  • check
    Create your own code library
  • check
    MessageBox & Format Builders
  • check
    File Processing & Loops Wizards

$60

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