VBA Project examples

See my second online demonstration video!

See my first online demonstration video!


Most of these examples are based on CMM inspection data. The tools used to create these programs can be used in any industry or activity. The intent is to show the flexibility available using VBA and VB.Net. I am working on generating some additional working or visual examples also.

IGES Generator: I developed a program to generate an IGES file from inspection results. This allowed for graphical viewing of inspection date (points and deviation lines) in a CAD program instead of more expensive CMM inspection software. It also allows viewing of graphical results available to anyone with CAD which greatly expands the number of users able to view results. This also reduces some of the burden on CMM programmers and Inspectors. [example coming soon]

Graphics results to CAD: I developed programs to directly transfer inspection results from Excel to CAD systems for visualization. [example]

Statistical Analysis Tool: I developed a program to retrieve inspection results from multiple part inspections. This tool includes a dynamic user interface and functionality to statistically evaluate each individual point or inspected feature as well as including statistical charting.

Automatic form population: I have developed multiple programs to automatically populate various forms from inspection result data. One example is an AS9102. [example coming soon]

Automated Graphic Results:  I have generated programs to automate deviation mapping. What this does is when an inspection file is read in, the deviations for specific points will populate a sheet that depicts the point location in some way. [example]

General Report Formatting tool: I have developed a complete formatting package to provide a consistent platform for reporting and data processing. The tool includes a number of features:

  • Reads in Data from 2 entirely different data sources. This enables the evaluation to be the same in multiple platforms.
  • Built in filtering to easily evaluate PASS/FAIL criteria and borderline conditions.
  • Ability to export point data in a variety of formats (.csv, x,y,z,i,j,k).
  • Functionality to email and send text messages when part data is ready for review.



Comments are closed.