Skip to Navigation | Skip to Content

Devcenter

Overview

MiniTutorial - Introduction to Using VBA

In this MiniTutorial, you will learn the basic concepts necessary to use Visual Basic for Applications (VBA) to extend Proto’s functionality. This tutorial has taken most people between 15 - 45 minutes to complete.

MiniTutorial - Introduction to Using VBA (PDF)

Download the MiniTutorial PDF.

MiniTutorial - Introduction to Using VBA (ZIP)

Download a ZIP of the MiniTutorial resource files.

You will also need to download and unzip the most recent copy of the Getting Started Components.

MiniTutorial Overview

In this MiniTutorial, you will learn how to use Visual Basic for Applications (VBA) within Proto to process data and interface with other applications through Automation. The VBA Integrated Development Environment (IDE) in Proto is the same VBA IDE that is found in MS Excel, Access and other Office applications, and should be familiar to people with programming experience. You will:
  • Learn about the most common uses of VBA to extend the functionality of Proto.
  • Walk through some VBA scripts and learn what they do in Proto.
  • Insert a pre-configured VBA module in Proto.
  • Learn the commands to manipulate Entrysets and communicate between VBA and Proto.
  • Explore VBA scripts on your own to process Entrysets, connect to databases, interface with MS Outlook and parse the XML from a Craigslist search.