Available Onsite Only
About Our Onsites
Combine the speed and simplicity of FORTRAN with Excel VBA to develop lightning fast
user friendly apps.
Our FORTRAN and Excel VBA training shows you how to
integrate legacy and new FORTRAN code with Excel VBA combining the speed and simplicity of
FORTRAN with the visual interface capabilities of Excel and VBA.
Questions? 1.805.498.7162 Customers >
The details about our
interfacing Excel VBA with FORTRAN training.
- Audience: Engineers,
scientists and technicians
- Duration: 8:30 AM - 4:30 PM
- # of Days:
3-days
- Instruction Type: Hands-on, live, instructor taught training
- Full EAE Manual Included: 2200 + page Microsoft Excel Aided
Engineering and Science manual full of Excel tips, how-to-do topics and Excel examples included with the training. Details >
- Excel Versions: 2007-2019, Office 365, Windows and Mac
- Free Repeats:
Repeat your Excel training. Details >
- Personal Examples: We review our attendees personal examples in our training instruction
- Available Training Formats:
_EMAGENIT_2019.png)
Our full EAE manual is included in our training.
Key topics covered in our Interfacing Excel VBA with FORTRAN training.
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.
The key skills learned in our interfacing Excel VBA with FORTRAN
training.
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
The skills you need for our interfacing Excel VBA with FORTRAN training.
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.
Our interfacing Excel VBA with FORTRAN training syllabus.
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
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)
_EMAGENIT_2019.gif)