Using Fortran with Excel VBA for Engineers and Scientists Self-Study Manual

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.