Interfacing Excel VBA with FORTRAN
for Engineers and Scientists

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.

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

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.

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

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

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