Interfacing Excel VBA with FORTRAN for Engineers and Scientists

Interfacing Excel VBA with FORTRAN Description

Our Our 3-day "hands-on "FORTRAN DLL and Excel VBA training shows you how to link FORTRAN code with the power of Excel VBA. Discussed is how to use Microsoft Excel VBA as a front and rear end information processor for your FORTRAN programs and includes a full Excel VBA language review stressing data processing. Our training also shows you how to layout visual interfaces in Excel that communicate with your FORTRAN code. Also discussed is how to create FORTRAN DLLs from legacy FORTRAN source code and mix the two languages together to form a solution. Taught by an engineer

Key Skills Learned in Interfacing Excel VBA with FORTRAN

Key Skills You'll Learn in Interfacing Excel VBA with FORTRAN

Key Excel VBA skills learned:

What is VBA?
A complete review of the Excel VBA Editor and its features
A complete review of the Excel VBA language including procedures, loops, logic, variables, functions, properties, methods and objects
A complete review of how to build a program that meshes Excel with the VBA programming language
How to use beginning Excel VBA to control key Excel engineering | science features like sorting, filtering, pivot tables, text-to-columns, removing duplicates
How to use VBA to control worksheets and workbooks including adding, opening, naming and saving
How to use beginning VBA to control worksheet cells and ranges including arrays, values, copy and paste, names, fonts, colors, borders and number formats
How to build engineering and science calculations in Excel VBA including using worksheet functions and VBA functions
How to manage engineering and science worksheet information including inserting, deleting, moving, and copying and pasting rows and columns
How to use beginning Excel VBA to process engineering and science data on single and multiple worksheets
How to build VBA code that adapts to changing worksheet data size and position
How to build engineering and science charts use beginning VBA
How to use Excel VBA to create visual dashboards that control your FORTRAN programs
How to use Excel VBA to create powerful custom worksheet functions that can be used for calling FORTRAN programs
How to design and compile FORTRAN DLL's
How to call FORTRAN DLLs from Excel Visual Basic (VBA)
How to pass scalars, strings and arrays to FORTRAN DLL procedures from VBA
How to convert current FORTRAN code to a FORTRAN DLL standard

Interfacing Excel VBA with FORTRAN Skill Requirements

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

Opened or saved a workbook
Learned about worksheets, cells and cell references like A1
Copied and pasted worksheet data
Performed basic cell formatting tasks
Typed data in cells and built basic formulas
Used a worksheet function like SUM, COUNTIF...
Have used FORTRAN before or have been exposed about it. Basic syntax will be reviewed.

Interfacing Excel VBA with FORTRAN Training Topics Outline

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

Day-1

How to Use the Visual Basic Editor to Control Your Excel VBA Programs

A complete review of the Excel VBA Editor, it's windows and how to insert, delete and control modules
What is an Excel VBA project, module and procedure and how are they used to create beginning Excel VBA programs
How to use the VBA Editor's debugging tools to correct your engineering and science programs

Interfacing Excel VBA with FORTRAN Onsite Online Details

Full Excel VBA Language and Programming Review

A complete review of the beginning Excel VBA language including how to use variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
How to construct an Excel VBA program including how to translate your ideas into a program that combines both Excel with VBA
What are objects, properties and methods and how do you use them in Excel VBA programs
How to control Microsoft Excel using VBA. In other words how to figure out and actually use the command.command.command VBA syntax
A complete review of program logic (If, Select Case...) and how to translate your tasks into logic in your VBA computer code.

How to Use Excel VBA to Control Cells, Ranges, Worksheet Formats and Table Data for Your FORTRAN Programs

How to use Excel VBA to control cells and ranges
How to use beginning Excel VBA to copy and paste worksheet data
How to use Excel VBA to gather worksheet data, perform calculations and output back to a worksheet
How to use beginning VBA to control your cell and range names, the key to developing advanced engineering | science programs that upload and download information
How to use VBA to control worksheet formats including cell number formats, fonts, colors, alignments and borders
How to use Excel VBA to automatically find and map resizing data fields on your worksheets
How to control data on a worksheet including inserting, deleting and moving cells, rows and columns

Interfacing Excel VBA with FORTRAN Free Repeats

How to Perform Engineering and Science Calculations in Excel VBA

How to write a formula (called an expression) in your beginning VBA code
How to run VBA functions and worksheet functions in your code, the key to building advanced engineering | science modeling and data tools quickly
The key VBA functions and worksheet functions you should know for your engineering and science tasks
How to analyze dates and times in your programs using VBA functions and worksheet functions
How use beginning Excel VBA to automatically map range and cell references
How to create custom worksheet function in VBA and use them on the worksheet for modeling and data processing purposes

How to Use Excel VBA to Control Your Engineering | Science Workbooks and Worksheets

Workbook and worksheet control
How to use beginning VBA to open, save, add and close workbooks
How to use Excel VBA to add, move and rename worksheets

How to Use Excel VBA to Automatically Find Workbooks, Worksheets and Cells

Finding Excel information without knowing names or position, the key to developing advanced data processing systems that think and adapt by themselves
How to use beginning Excel VBA to control Excel's interfaces, like the Open dialog box, to find and open your workbooks
How to use the FOR...Each Next loop in Excel VBA to scan for workbooks and worksheets based on their properties, not their names, the key to developing a data storage system in Excel
How to use the Find feature in beginning Excel VBA to find worksheet cells without knowing their location
How to use the Set statement to track your workbooks, worksheets, cells and ranges

Day-2

How to Use Loops and Logic to Pre/Post Process Worksheet Data for Your FORTRAN Program

Why follow database table guidelines when developing tables on your worksheet
How to organize your engineering |science data in properly designed tables on your worksheet
How to process data on a single worksheet using VBA loops and logic
How to process data on multiple worksheets using VBA loops and logic
How to read dates and times in your loops and process them in VBA

How to Use Excel VBA to Control Key Engineering and Science Excel Features

How to control Excel's Autofilter and Advanced filter with VBA
How to use beginning Excel VBA to control the Sort feature, Remove Duplicates feature and Text-to-Columns feature
How to tie these features into Excel VBA programs using loops that process massive quantities of data

How to Create Engineering | Science Charts and Pivot Tables for Your FORTRAN | Excel VBA Programs

How to use beginning Excel VBA to create chart sheets and embedded charts from worksheet data
How to use Excel VBA to update your chart's data without rebuilding it
How to use VBA to format charts
How to build pivot tables using Excel VBA and the Macro Recorder

How to Create Basic Dashboards for Your FORTRAN | Excel VBA Programs

How to layout a program interface on the worksheet that will control your FORTRAN programs
How to layout a program interface on the worksheet that will keep track of the files needed in your program
How to layout charts and drawing shapes on the worksheet to create that high tech dashboard look
How to use ActiveX controls on the worksheet with your dashboards
How to run your VBA procedures from your dashboard, the logic and procedure groupings behind doing it

Day-3

How to Mix the FORTRAN and Excel VBA Languages

How to create a Declare statement in Microsoft Excel VBA
How to Call a FORTRAN DLL from a VBA Sub Procedure
How to call a FORTRAN DLL from a worksheet formula using a VBA Function procedure
How to pass scalars, strings and arrays to FORTRAN DLL procedures from VBA
How to convert existing FORTRAN code into DLL compliant form
Microsoft Excel VBA limitations when communicating with FORTRAN
How to create a FORTRAN DLL
How to output your FORTRAN program results in different workbooks and worksheets
How to fill out a form with your FORTRAN data using Excel VBA loops and logic
How to fill out date tables, status tables.. with worksheet data using Excel VBA loops and logic

Interfacing Excel VBA with FORTRAN Training Details

Audience: Engineers, Scientists and Technicians
Time: 8:30 AM - 4:30 PM
# of Days: 3-days
Type: Hands-on, live, instructor taught training
Manual: 2000 + page Microsoft Excel Aided Engineering and Science manual full of Excel tips and how-to-do topics included with the training
Platform: Windows 7 - Windows 10, Mac users welcome
Excel Versions: 2007-2016, Windows and Mac
Free Repeats: Repeat your Excel training as many times as you like, no date or limit, click here for details
Examples: We review our attendees personal examples in our training instruction
Training Formats:
- Company Onsite
- For self-study, purchase Microsoft Excel-Aided Engineering and Science. For company onsite information, please contact us 1.866.924.6244
Additional Training:

Onsite Details

Onsite Only

Onsite Details

Interfacing Excel VBA with FORTRAN Contact Information

Contact EMAGENIT Directly

Phone Number: 1.866.924.6244
Business Hours: 8:30 - 5:00 PM PT
email: adv_excel_question@emagenit.com

Your Contact Information

*Name:
Company:
Company Web:
Country:
Phone #:
Ext:
*e-mail:
	Contact me directly by phone when this is received

*Required information to complete form. Privacy Policy

Workshop Questions

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information and Submit

	Send me on-site workshop information
	Send me public training workshop information
	Send me self-study manual information
	Send me live online course information

Before clicking the Submit button, please fill in at least your name and email under Your Contact Information. Privacy Policy