Interfacing Excel VBA with Fortran Self-Study Manual

About the manual.

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. Over 1500 hours of Fortran / Excel VBA research have gone into assembling this manual.

Specifically, our manual documents the Excel VBA / Fortran calling rules in detail. These rules include compiler directives, Declare statements, argument list design, and argument data typing.

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 fully documented manual problems.

Our examples start by showing 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 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.

Learn to design Fortran DLLs, Excel VBA calling rules, and VBA Declare statements that access them.
Learn to pass strings, arrays, numbers, Booleans, user types, dates, and complex numbers to Fortran from Excel VBA.
Learn to design VBA code that iterates through workbooks, text files, and databases and then use the data in Fortran.
Learn to design worksheets to store Fortran program parameters, array data, and use VBA to rapidly pass them to Fortran.
Learn to design event driven worksheets, userforms, charts, and shapes and turn them into high-tech GUIs for legacy Fortran programs.
Learn to design worksheet based models that run Fortran and various numerical methods.

What you will learn in our manual.

Some detailed manual topics.

VBA Editor window, VBA modules, and debug tool review
Complete VBA language syntax review including procedures, loops, logic, variables, arrays, expressions, and functions
Excel object, property, and method review for VBA
How to call a Fortran DLL from a VBA Sub and Function procedure; Declare statement and calling syntax rules
How to design a Fortran routine to be called from Excel VBA; compiler directives, data types, strings and arrays
How to pass different argument types from Excel VBA to a Fortran DLL; data type rules, passing conventions, strings and arrays
How to Pass Data from Fortran Back to Excel VBA
How to compile and debug a Fortran DLL in Visual Studio
How to pass data to/from Fortran using text files in Excel VBA
Fortran DLL design tips; using old Fortran code and writing new code
Controlling Excel, Workbooks, Worksheets, Windows, Page Setup and PivotTables with VBA
Controlling Ranges, Range Fonts, Range Borders, Range Colors with VBA
Controlling Conditional Formatting, Data Validation, Sorting, Excel Tables and Queries with VBA
How to build custom worksheet functions in Excel VBA that run numerical methods, Fortran code, and process data
Using Excel VBA to build and manage system models, trade studies, and automate Solver
Data processing strategies for processing data in single and multiple workbooks using Excel VBA
How to use VBA to control and build Excel charts
Using ActiveX controls, worksheets, userforms, events, shapes, and charts to build UIs for your Fortran code
How to control databases and text files using ADO, SQL, and VBA
Excel dashboard design
Using Excel VBA to automatically draw technical illustrations on the worksheet

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:	1600+ pages with over a 100 fully documented 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