Home > Excel Class Guide > Calling Excel VBA Fortran

Multi-Language Programming with Excel VBA / Fortran Class

Calling Excel VBA Fortran

Learn to combine the interface and data abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling and analysis tools.

  • Our 3-day class covers the essentials you need to know about running Fortran DLLs from Excel VBA.
  • It provides a review of the Excel VBA language and syntax along with the Fortran coding rules to run DLLs from VBA.
  • It will show you how to automate key Excel elements that are commonly used with Fortran DLLs.
  • Other key topics include designing Excel VBA interfaces to control Fortran; pre / post processing Fortran data with VBA; automated charting; and modeling.
  • Join us and our class will show you those elusive coding rules for Excel VBA Fortran and much more >.

See the must know topics you will learn.

See What You Master
Close

No time to attend, get a manual instead.

Covers the Excel VBA topics needed to design powerful UI driven data processing, analysis, modeling, and database tools.

  • Contains our complete Excel VBA write-up covering fundamental to advanced Excel VBA topics.
  • Discusses how to create event driven interfaces using VBA, userforms, ActiveX controls, charts, and worksheets
  • Covers key topics including multi-folder / workbook data processing; automated models; controlling databases; and automating Solver / Analysis Toolpak.
  • 1000's of lines of useful code, 100's of real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel VBA Fortran topics covered in class.

Excel VBA Fortran Preview

Class examples.

Pricing and class options.

corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class Syllabus

Day-1

Why Run Fortran from Excel VBA?

Excel VBA Language Review Emphasizing Fortran DLL Communication

Must Know VBA Functions and Excel Worksheet Functions Used in Excel VBA / Fortran DLL Apps

Controlling and Looping Through Workbooks, Worksheets, and Folders for Fortran DLL Data

Using Excel VBA to Process Input / Output Fortran Data on the Worksheet

Day-2

Calling Fortran DLLs from Excel VBA Procedures

Designing a Fortran Routine to be Called from Excel VBA

Passing Different Argument Types from Excel VBA to a Fortran DLL Including Strings

Passing Data from Fortran Back to Excel VBA

Passing Data to Fortran from Excel VBA Using Text Files

Compiling and Debugging a Fortran DLL

Day-3

Creating Program Interfaces (UIs) for Your Excel VBA / Fortran DLL Apps

Assembling Excel Models That Run Fortran DLLs

Creating Charts with Excel VBA to Display Your Fortran DLL Output

Using VBA to Create Worksheet Tables and PivotTables to Display Your Fortran DLL Output

Visualizing Your Fortran DLL Output Using Excel's Drawing Shapes

Additional Classes:
Microsoft Excel
for Engineers / Scientists
Excel Data Analysis
for Engineers / Scientists
Excel VBA
for Engineers / Scientists
Excel VBA Data Analysis
for Engineers / Scientists
Advanced Excel VBA Design
for Engineers / Scientists
Mixed Language Programming
with Excel VBA / Fortran
Microsoft Excel for Engineers / Scientists Excel Data Analysis for Engineers / Scientists Excel VBA for Engineers / Scientists Excel VBA Data Analysis for Engineers / Scientists Advanced Excel VBA Design for Engineers / Scientists Mixed Language Programming with Excel VBA and Fortran

Excel VBA Fortran skills needed for the class.

Select this Excel VBA training if you or your group have:

  • Operated Excel's basic data processing tools like AutoFilter, Text to Columns, Remove Duplicates, Sort
  • Used worksheet functions before and know how they operate
  • Copied and pasted worksheet data
  • Typed data in cells and built basic formulas
  • Created charts and used drawing shapes
  • Used VBA before, do not have to be an expert
  • Been exposed to the concepts of basic programming like loops, logic and variables
  • Used Fortran before or have been exposed to it, basic syntax will be reviewed

The class details.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Contact us by form.

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved