Interfacing Excel VBA with Fortran Self-Study Manual

Learn to design Fortran DLL's and combine their speed with the GUI, data processing, visual display, and modeling abilities of Excel VBA. Manual Examples >

Interfacing Excel VBA with Fortran

Covers everything on running Fortran from VBA plus our complete Excel VBA write up for modeling, data processing, and GUIs.

How our manual can help you.

Interfacing Excel VBA with Fortran

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.

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

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.

Example1 Example2 Example3 Example4 Example5 Example6
  • 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.

Expert Excel Training

$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 October

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

Associated classes.

Need Help? Please call us at 1.629.207.9662

Copyright © 2002-2023

EMAGENIT All Rights Reserved