VII.1.8 Using COM component with excel
One advantage of programming FeResPost as a COM component, is that this allows to use the
component from other applications. For example, FeResPost can be used from Excel provided one
accepts to write some programming functions and subroutines in VBA. Several examples illustrate the
benefits of using FeResPost from excel:
- In Chapter VII.2 one shows how a small tool devoted to the automation of Classical
Laminate Analysis can be developed in Excel.
- The extraction of Results in Excel from a Nastran XDB file is illustrated in
Chapter VII.3.
- One shows in Chapter VII.4 how an entire post-processing project can be developed in
excel. This project allows to define the data in excel while the actual calculations are
managed by the programmed VBA modules that call FeResPost objects and methods.
- A very small example illustrating the use of BLOB and SQL with VBA in
section VII.1.9.