<< Click to Display Table of Contents >> Navigation:  Flexcom > Examples > J - Specialised Examples > J02 - Advanced Database Postprocessing >
Database Access via Excel VBA

Creating an Excel Visual Basic for Applications (VBA) macro is a powerful way of extracting data from a Flexcom results database. This method allows you to extract and process the data, do further calculations, or simply output it in a desired format. The use of conditional statements and loops is an efficient way of filtering and processing the data that is needed.

This section is divided into two articles:

•Node Positions Example describes, by way of a worked example, how to set up a simple VBA macro to access Flexcom database files.

•Element Statistics Example gives a brief overview of the methodology used to create a macro that calculates statistics such as mean and standard deviation for various Flexcom outputs.