We've tried to create some 'interesting' examples here using VBA code from the various applications that support VBA. Most obvious are the Microsoft Office components Access, Excel, Outlook, PowerPoint and Word. There are also some other software packages represented.

If you are unfamiliar with programming in the Office VBA environment, consider taking a class with us--see the Training section.

I Get It! Development provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. These articles assume that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. These examples assume that you have licensed copies of all relevant software installed on the machine upon which the examples will be run.

Microsoft Access

Use Adobe and Access VBA to insert form images into your database documentation
Create 'facing page' page headers and footers (different footers on even and odd pages)

Microsoft Excel

Find a numerically formatted date in any text string
Create Adobe PDF files from all Excel workbooks in a folder
How to loop through any sized region (Do...While, For...Next, For Each...Next loops)
The Un-PivotTable: A case study using training and Excel VBA

Microsoft Word

Create Adobe PDF files from all Word docs in a folder
Format emails without all the forwarded-email folderol

Adobe Acrobat

Use Adobe and Access VBA to insert form images into your database documentation
Create Adobe PDF files from all Word docs in a folder
Create Adobe PDF files from all Excel workbooks in a folder

TechSmith SnagIt

Use SnagIt and Access VBA to create JPG image files of all of your forms