Interfacing Excel VBA with Fortran Self-Study Manual

How our manual can help you.

Our self-study manual covers everything you need to know about creating Fortran DLLs and running them from Excel VBA GUIs, data tools, and models. Our manual will show you in-depth the complete Excel VBA / Fortran calling rules including compiler directives, declare statements, argument list design, and argument data typing.

In addition, it will show you how to modify legacy Fortran code to run from Excel VBA and how to compile 32-bit and 64-bit Fortran DLLs in Intel Fortran.

Our manual also includes our complete write-up on our beginning through advanced Excel VBA topics. Topics include GUI design, data processing methods, model construction, and automated chart design.

Examples of our manual problems.

Our examples will show you the calling, data typing, and Declare statement rules for running Fortran DLLs from VBA. They break down the various components needed for Fortran / VBA communication in easy-to-follow problems.

Our examples will teach you how to use VBA to iterate through workbooks and text files processing data for use in Fortran. You’ll also discover how to rapidly create text files for use in your Fortran routines and generate report workbooks and store them.

Our examples cover how to organize Fortran settings and data using the worksheet and VBA userforms. They’ll show you how to build adaptive worksheets that react to inputs and Fortran output. You’ll also discover how to automate charts to visualize your Fortran data.

Our examples show how to rebuild legacy Fortran programs and develop adaptive GUIs in Excel VBA to control them. They'll show you how to combine userforms, worksheets, events, ActiveX controls, shapes, and charts to control your Fortran inputs and visualize outputs.

Our examples demonstrate how to layout worksheet models and run their calculations in Fortran. You’ll see how to organize inputs / outputs for easy access in VBA and use cell names to track them. They also show how to run Fortran from custom worksheet functions.

Our examples cover how to organize data for numerical methods so it can be quickly run in Fortran. You’ll see how to use VBA to discretize equations and data and quickly store it on worksheets for later use. They’ll also show you how to import that data rapidly into VBA.

Complete review of the Excel VBA language, VBA Editor, modules, and the Editor debug tools
How to track Excel objects and use their properties and methods in your code
Using VBA to control Key Excel elements like workbooks, worksheets, ranges, formulas, fonts, cell colors...
How to process data in worksheets and text files using Excel VBA
Using Excel VBA to automate charts and create reports
How to design Fortran DLLs, VBA Declare statements, and use VBA / Fortran calling statements
How to pass strings, arrays, numbers, Booleans, user types, dates, and complex numbers to Fortran from Excel VBA
Designing VBA code to iterate through workbooks, text files, and databases to collect data and pass it to Fortran
Using worksheets to store and opranize Fortran program parameters and array data
Creating advanced GUIs (userforms, ActiveX, events, Ribbon ...) to control Fortran DLL code
Designing worksheet based models to run Fortran DLLs
Creating visual displays in Excel for your Fortran data

What you will learn in our manual.

$129.00

Buy the manual now and apply its price to a class later. Just type your transaction # in the comments when purchasing a class.

Coming in 2025

Manual specifications and download.

For:	Engineers and Scientists
Format:	ADOBE PDF and Excel Files as zip file download
Details:	Covers creating Fortran DLLs, Fortran programming rules, and beginning to advanced Excel VBA
Book:	Fully illustrated, step-by-step instruction, with over 150 fully documented Excel VBA and Fortran examples
Platform:	Windows 7 and above
Download:	Sent within 3 hrs after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:	Excel 2013 for Windows and above