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 12+ years of Excel training can help supercharge your Excel 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

Newsletter Contact Us Training Help
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.

Workshop Details

  • 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
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.
Training Options, Signup and Self-Study

   

  • Our Advanced Excel VBA workshop also covers the information presented in this workshop.

  • West coast dates, times and prices on Signup page. Use the Signup buttons above to view.

  • For a complete outline, consult the Workshop Outline section below. Read about EMAGENIT and our Customers.

  • Our webcast workshops are taught live with voice, hands-on and broadcast directly to your computer from our facility (details). We can reach anywhere that has internet broadband.

EMAGENIT's Training Location

Public Location: Thousand Oaks, CA

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.

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

 

 

 


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-2010 EMAGENIT All Rights Reserved