FORTRAN DLL and Microsoft Excel Visual Basic Programming Workshop Outline

In our FORTRAN DLL workshop, you will learn the methods behind coupling Excel, VBA and FORTRAN to upgrade existing FORTRAN programs with new Excel interfaces or build system models that have lightning speed. Read below and see how our 14 years of Excel training and software design can help supercharge your Excel VBA skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

NASA Award for Microsoft Excel Design

EMAGENIT received an award from NASA for its software design in Microsoft Excel and VBA for the Mars Rover. We provide training for customers like AMGEN, General Dynamics and Caterpillar. Read below to learn more about our Beginning VBA Training.
 

Workshop Availability
  • Onsite, Self-Study*, Public*, Webinar*

*Advanced VBA covers the same basic material in a less focused format. Click here for engineering and science.

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.

Note: Our Advanced Excel VBA workshop covers most of the information presented in this workshop. The signup for Advanced VBA is below.

Workshop Details

  • 2-day workshop

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Engineers and Scientists

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on

Workshop Outline

In this 2-day "hands-on" workshop 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
Intended Audience
  • 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.
Information Request

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.

First Name:
Last Name:
Company:
Zip Code:
Country:
Work Number:
Ext:
e-mail
Information type:
Send me on-site information and pricing
Send your latest public workshop schedule and pricing
Contact me directly via the phone number provided
Keep me informed about EMAGENIT workshops and products
Privacy Policy
Newsletter Contact Us Training Help
 

 

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2011 EMAGENIT All Rights Reserved