I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

VBA 09 Sample App

Here I present a generic VBA template which shows some basic elements of good programming style.

We create an email which shows a list of the capacity of all operating nuclear reactors, aggregated by country and decade. Please notice that I used just fictive test data. If you are interested in real data look at the Guardian's website, for example.

This is done in four steps:

1. Read the input file
2. Reduce the input data to country, decade of start and net capacity
3. Create a Pivot table which aggregates by country and decade
4. Prepare an email

Generic_VBA_Template_01_Screen

The zipped 258 KB Excel 2007 generic VBA sample application you can download here. Download, open and use at your own risk. Please read my disclaimer.

Please notice that you should adjust filenames in sheet Param to your environment first before you run this application.

[Previous]  [End = Back to Intro Overview]

Sulprobil   Get it done   Contact   Disclaimer   Download