Welcome to the Sample Code section
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