listi.net

What is VBA?

It is an acronym that stands for Visual Basic for Applications and also goes by the name Macros.

VBA is a programming language that comes with all Microsoft Office programs.

It allows you to automate tasks to save you time.

Excel and Word have a Macro recorder.

It takes Excel from a great tool to a super-productivity tool and allows Excel to do just about everything.

Almost all advanced applications of Excel will use VBA.

Some of the built-in features of VBA are:

Macro recorder

Debugger

Access the Windows API

Interact with other Office programs

Do anything Excel can do over and over

In Excel VBA I've been able to:

Process files (read, write, update, delete, change, directories)

Send emails

Create Webpages that change in real-time via ASP

Time tracking

Alarms

Shortcuts

Running programs

Monitor a process

Do batch processing

Learning

Finding Data on a computer

Analyzing all Excel files on a computer

Generate PowerPoint slides from various sources (database, PPT, Excel, txt files)

Automate manual tasks

Reporting

Generate files in a specific format like XML

formating output