This example shows how SCOUT work can be done using Visual Basic for Applications (VBA) and Excel tables. The required tables, VBA programs and menu entries are stored in the Excel file Scout.xls .
The following ingredients are needed and described: |
•A set of VBA procedures (also called 'macros' in this document)
•Excel menu items to execute the VBA routines