Running Fortran DLLs from Excel VBA - Live Class

Learn to combine the speed of Fortran with the GUI, charting, modeling, and data processing capabilities of Excel VBA to create lightning-fast engineering and science tools. Class Examples >

Next Class: Check Dates

Calling Excel VBA Fortran

How our class will boost your Excel VBA Fortran skills.

Boost Excel VBA Training

Our 3-day class shows how to create powerful tools by combining the speed of Fortran with the GUI, data, and modeling abilities of Excel VBA. It shows how to use the key Excel VBA and text file elements necessary to process, pass, return, and display Fortran DLL data.

Also covered is how to design and compile Fortran DLLs or upgrade existing Fortran code to run from VBA. Our class also discusses how to automate Excel's data tools and charts; build models; and create GUIs from userforms, shapes, worksheets, and ActiveX to run Fortran DLLs.

Read our detailed outline > below and see what you'll discover in our class.

What you'll learn in our class.

Excel VBA Picture white
Close Examples
Forward... Forward...

Learn how to design key elements for Fortran DLL execution like Declare statements, argument lists, data types, and arrays.

Learn to use VBA to control ranges, perform table lookups, find data, loop through worksheets, and import it into Fortran.

Learn to discretize formulas, read ranges into VBA as arrays, and pass arrays to numerical methods run in Fortran.

Learn to use VBA to create report workbook / worksheets, format Fortran data, and create charts to visualize Fortran results.

Learn to layout worksheet GUIs using ActiveX and Data Validation, and use VBA worksheet events to run Fortran and visualize results.

Learn to design userforms with ActiveX controls and use VBA events to run Fortran and display results.

Learn to layout worksheet models, organize inputs / outputs, and design custom worksheet functions to run Fortran DLLs.

Learn to compile both 32-bit and 64-bit Fortran DLLs using Intel Fortran and Microsoft Visual Studio.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8
  • Full review of the VBA language, Excel objects, VBA Editor, and debugging
  • How to track worksheet ranges, headers, and data in your VBA code
  • Running Excel and VBA functions in your code to analyze and lookup data
  • Using loops and logic to process and assemble Fortran DLL data and arrays
  • Looping through workbooks, worksheets, and folders to gather data for Fortran
  • Various ways to rapidly output Fortran data to the worksheet and format it
  • Using Excel VBA to read / write Fortran DLL text files
  • Basic coding strategies for designing and retrofitting Fortran code to run in DLLs
  • Complete Fortran and VBA procedure calling and argument data typing rules
  • Rules for compiling 32 and 64 bit Fortran DLLs
  • Creating worksheet GUIs and events to run your Fortran DLLs
  • Using userform, ActiveX controls, and events to run Fortran DLLs
  • Designing worksheet models and custom worksheet functions (UDFs) to run Fortran DLLs
  • Using VBA to create charts, shapes, and PivotTables to display Fortran DLL output

Some key topics we cover in class.

Excel VBA Fortran Training Topics

4 ways to train.

Virtual Signup
Live Virtual

View the dates / signup for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
Public In-Person

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup >   Learn More >

Manual Information
Manual

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

Onsite Details
Onsite

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

Day-1

VBA Language, Module, and Editor Review for Fortran DLL Projects

*This section discussed throughout the class when needed

Controlling Ranges, Formats, Functions, and Table Lookups with VBA

Using VBA to Control Workbooks, Worksheets, Folders, and the Windows Registry

Using VBA to Assemble, Process, and Output Fortran Data

Controlling and Processing Text Data with VBA

Visualizing Fortran Output Using VBA, Charts, Shapes, and PivotTables

Day-2

Calling Fortran DLLs from Excel VBA Procedures

Designing a Fortran Routine to be Called from VBA

Passing Data Types Between Fortran and VBA

Using Text Files to Pass Data to and From a Fortran DLL

Compiling and Debugging a Fortran DLL

Day-3

Creating Worksheet GUIs to Control Your Fortran DLLs

Creating Userforms and Folder / File Pickers to Run Your DLLs

Designing Excel Models to Run Fortran DLLs

Additional Class Information

Prerequisites for our Excel VBA Fortran training.

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