Mixed Language Programming with Excel VBA and Fortran - Class

Why rewrite verified Fortran code? Use Excel VBA to enhance its UIs and run it. Learn to combine the GUI, data processing, and charting abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling, data, and reporting tools.

Next Class: Check Dates

Calling Excel VBA Fortran

Seamlessly fuse Fortran and Excel.

Class overview.

Our 3-day class shows you hands-on how to create powerful tools that fuse Excel VBA with Fortran. Stressed is how to use Excel VBA as a front and rear end information processor and GUI for your new or legacy FORTRAN code.

Our training covers all the Excel VBA elements necessary to gather, pass, and return Fortran DLL data. Also covered is how to upgrade your Fortran code so it can be compiled as a DLL and run from Excel VBA. The class uses Intel Fortran and Visual Studio to create Fortran DLLs (both can be downloaded for free).

Also reviewed is how to assemble models; automate Excel's data tools and charts; command text files; and how to build hi-tech GUIs from userforms, ActiveX controls, shapes, worksheets, and events.

Join us and our class will show you how to upgrade your Excel VBA apps with the computational abilities of Fortran.

View Customers >

Some key topics we cover in class.

Newsletter Signup
Newsletter Signup >

Prerequisites for our Excel VBA Fortran training.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $850.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $950.00 >

Manual Information

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

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

Download Class Brochure


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


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


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

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved