Interfacing Excel VBA with Fortran Self-Study 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. 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.

• 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