Interfacing Excel VBA with Fortran Manual

Covers Fortran DLL code design and how to run them from Excel VBA and the worksheet.

• Full review of the Excel VBA language and Fortran DLL calling rules.
• Covers running Fortran DLLs from Excel VBA UIs, data tools, and models.
• In depth Fortran DLL and VBA syntax rules for receiving and passing data.
• Covers Excel model, data tool, and UI construction.
• Buy a manual now, apply the price towards a class later. They are free with our classes.

Manual specs.

What's in our manual.

Our 1600+ pg Excel VBA / Fortran manual covers how to create Fortran DLLs that run from with Excel VBA models, UIs, and data tools. It discusses how to call Fortran from VBA procedures and events and User Defined Worksheet Functions run from formulas. Also discussed are the key essentials for VBA / Fortran routine communication: compiler directives, declare statements, passing conventions, data types, passing arrays, passing strings, passing numbers and passing text files. Our manual also shows how to convert existing Fortran programs to a DLL standard and also provides a full write-up on beginning through advanced Excel VBA topics along with program interface design.

Click to enlarge, scroll < > if hidden.

Must know Excel VBA Fortran topics covered in the manual.

• 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

Price: $119.00