Workshop Details

Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Workshop Manual: Price and Buy

Public Training: Review Our Workshops

Onsite Training: Details

Web Cast Information: Review Our Workshops

Workshop and Manual Overview

In this 2-day "hands-on" engineering workshop, you will learn:

• 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.

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

Workshop Topics

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

Workshop Materials

• The workshop manual contains helpful Microsoft Excel VBA FORTRAN programming strategies and code in a user-friendly format.
• The manual illustrates the Microsoft Excel VBA/FORTRAN topics using state of the art screen shots and 3-D graphics.
• Each workshop participant receives a comprehensive CD-ROM that contains the workshop examples and reading materials.

Who Should Attend

• 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.

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California 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 on-site Microsoft Excel VBA courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.