|
Why Use the
FORTRAN DLL and Microsoft Excel VBA Combination? |
A
vast legacy of FORTRAN engineering code is available for engineers and
scientists to utilize. Redesigning
this code in Microsoft Excel VBA is not time or cost effective. Luckily FORTRAN routines can be executed directly from
Microsoft Excel Visual Basic in the form
of a FORTRAN DLL (Dynamic Link Libraries). Using the FORTRAN DLL technology in
conjunction with the Microsoft Excel worksheet, elaborate engineering
applications and system models can be readily developed in Excel.
FORTRAN DLL overview
|
What You Learn at a Glance |
-
How to design and compile
FORTRAN DLL's
-
How to call FORTRAN DLLs from
Excel Visual Basic (VBA)
-
How
to pass scalars, strings and arrays to FORTRAN DLL procedures from VBA
-
How to use Microsoft Excel and
VBA as an integration platform to FORTRAN DLL results
-
How to convert current FORTRAN code to
a FORTRAN DLL standard.
-
2-day workshop
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Engineers and
Scientists
-
Platform: Windows
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on
|
Workshop Outline and Self-Study
Manual Content |
In this 2-day "hands-on"
engineering workshop or self-study manual, you will learn:
Day-1
- Microsoft Excel's strategic placement in the
engineering process and its engineering capabilities
- How to create a Declare
statement in Microsoft Excel VBA
- How to Call a FORTRAN DLL
from a VBA Sub Procedure
- How to call a FORTRAN DLL
from a worksheet formula
- How
to pass scalars, strings and arrays to FORTRAN DLL procedures from VBA
- Excel VBA data typing issues
Day-2
- How
to convert existing FORTRAN code into DLL compliant form
- Microsoft Excel VBA
limitations when communicating with FORTRAN
- How to create a FORTRAN DLL
- How to use
Microsoft Excel as an integration platform for FORTRAN DLL solutions
- Engineering
professionals with a good understanding of VBA's core language
(variables, loops, logic decisions) and Microsoft Excel. Those attending should also have a basic understanding of the FORTRAN
language.
|
Training Options, Signup and Self-Study |

|
EMAGENIT's Training Location |
Hotel: Thousand Oaks
Inn
EMAGENIT is based in Thousand Oaks,
CA which is in the vicinity of Los Angeles county (LA County), Ventura
county, Santa Barbara county and San Diego county. We hold all of our courses
on-site nation wide.
We also webcast (webinar) our public workshops, consult our
webcast page for more information.
Our public workshops are a short commute for those living in:
-
Los Angeles, CA
-
Palmdale, CA
-
Westwood, CA
-
Santa
Barbara, CA
-
San
Fernando Valley, CA
-
Santa Clarita, CA
-
Newbury Park, CA
-
Westlake Village, CA
-
Camarillo, CA
-
Calabasas,
CA
-
Sherman Oaks, CA
|
-
Reseda, CA
-
Woodland Hills, CA
-
Hollywood, CA
-
Fillmore, CA
-
Ventura, CA
-
Moorpark, CA
-
Simi Valley, CA
-
Santa Monica, CA
-
Oxnard, CA
-
Pasadena, CA
-
Agoura, CA
|
For more information about our public workshops,
visit our public workshops page our call us at
805.498.7162.
Submit a question to us via email at
fortran@emagenit.com
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at
1.805.498.7162 or 805.558.9277 for more information about this
workshop.
|
|
EMAGENIT
NASA Award for Excel |
 |
|
EMAGENIT received an
award for its involvement with NASA JPL in helping
redesign and integrate their conceptual Rover
mission software in Microsoft Excel. Click the
picture above for more detail about our Rover
involvement. To learn more about the NASA mission to
mars
click here. |
|
Awards &
Customers |
|