Multi-Language Programming with Excel VBA Fortran

Calling Excel VBA Fortran

Next Class: 5/31/2023

Combine the raw speed of Fortran with Excel VBA to produce amazing engineering and science tools!

  Why rewrite your verified Fortran code in another language? Learn to combine the UI and data abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling, data processing, and analysis tools.

Example1 Example2 Example3 Example4 Example5 Example6

Class overview.

What makes our training different?

Our 3-day class  shows you how to use Excel and VBA to produce powerful GUI driven tools for engineering and science. It focuses on how to combine the worksheet, ActiveX controls, shapes, pictures, userforms, events, and VBA to develop high-powered UIs that control things like calculations, models, charts, trade studies, and data processing.

Other key topics discussed include controlling folders and files; scanning multiple folders / workbooks for data; text file reading and writing, controlling databases; uploading / downloading / storing problem parameters; running batch file problems; and auto running Solver and the Analysis ToolPak.

Also reviewed is how to use shapes, pictures, charts, and VBA to develop powerful dashboard tools that display various statuses, KPIs, chart data, and technical diagrams. Join us and our class will show you how to push Excel VBA to the redline and create advanced tools that will solve your toughest tasks.

Onsite Classes Designed for Your Problems

Some key topics we cover in class.

Prerequisites for our Excel training.

Excel Manuals

Class time, duration, manual, and repeats.

Class syllabus and training options.

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 PDF

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

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 >

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

Copyright © 2002-2023

EMAGENIT All Rights Reserved