Home > Excel Class Guide > Calling Excel VBA Fortran

Calling FORTRAN DLLs from Excel VBA Class

Calling Excel VBA Fortran

Learn to combine the powerful UI and data abilities of Excel VBA with the speed of Fortran to produce problem solving engineering and science tools.

See What You Master
Close
Explore new frontiers.

How our class can help you.

Our 3-day class shows you how to combine Excel VBA's "off-the-shelf" features with the computational power of Fortran to produce lightning quick apps. There is a tremendous amount of legacy Fortran code and libraries out there that have been verified and tested but lack a modern interface. This class solves that problem.

In addition to the legacy aspect, modern Fortran itself is quite easy to learn and just blazingly fast when it comes to number crunching. It clocks in at about 40 times faster or higher than VBA when running simulations. Why not leverage it?

Join us and our class will show you how to unleash Excel VBA as pre/post processor to Fortran and shows you the coding specifics to get the job done quickly.

Free Repeats
Repeat your Excel workshop with us for an entire year for free.
Free Repeats
NASA Project
See how we helped NASA with the Mars Rover using Excel.
NASA
Discounts
We provide discounts to active / retired US Military and DOD.
Discounts
Customers
View our customers like Apple, Boeing, and the US Army.
Customers

Key VBA Fortran topics covered in class.

Excel VBA Fortran Preview

Click to enlarge, scroll < > if hidden.

Detailed class syllabus.

Class Syllabus Dates / Signup

Available: Onsite >

How we run the class: We focus our Excel VBA / Fortran class on what our customers need. When class begins, we analyze those needs and shift our outline appropriately. We will stress topics or add topics that our customers want. No two classes are ever the same with EMAGENIT.

Day-1

Why Run Fortran from Excel VBA?

Excel VBA Language Review Emphasizing Fortran DLL Communication

Must Know VBA Functions and Excel Worksheet Functions Used in Excel VBA / Fortran DLL Apps

Controlling and Looping Through Workbooks, Worksheets, and Folders for Fortran DLL Data

Using Excel VBA to Process Input / Output Fortran Data on the Worksheet

Day-2

Calling Fortran DLLs from Excel VBA Procedures

Designing a Fortran Routine to be Called from Excel VBA

Passing Different Argument Types from Excel VBA to a Fortran DLL Including Strings

Passing Data from Fortran Back to Excel VBA

Passing Data to Fortran from Excel VBA Using Text Files

Compiling and Debugging a Fortran DLL

Day-3

Creating Program Interfaces (UIs) for Your Excel VBA / Fortran DLL Apps

Assembling Excel Models That Run Fortran DLLs

Creating Charts with Excel VBA to Display Your Fortran DLL Output

Using VBA to Create Worksheet Tables and PivotTables to Display Your Fortran DLL Output

Visualizing Your Fortran DLL Output Using Excel's Drawing Shapes

Additional Classes:
Class Syllabus Dates / Signup

Excel VBA skills needed for the class.

Select this Excel VBA training if you or your group have:

  • Operated Excel's basic data processing tools like AutoFilter, Text to Columns, Remove Duplicates, Sort
  • Used worksheet functions before and know how they operate
  • Copied and pasted worksheet data
  • Typed data in cells and built basic formulas
  • Created charts and used drawing shapes
  • Used VBA before, do not have to be an expert
  • Been exposed to the concepts of basic programming like loops, logic and variables
  • Used Fortran before or have been exposed to it. Basic syntax will be reviewed

The class details.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: 8:30 - 5:00 PM PT

You can email us at info@emagenit.com >

Contact us by form.

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved