EAC
Tools is written in Visual Basic for Applications (VBA). VBA is
Microsoft's event-driven programming language built into most desktop Microsoft
Office applications. Microsoft continues to support and update the VBA
implementation in new Office features. VBA is used for professional and
end-user development due to its ease-of-use, Office's vast installed userbase,
and extensive legacy in business applications. VBA is the language of choice
for automation of tasks within Excel, allowing for the development of powerful
and complex macros and user-defined functions.
The EAC Tools add-in leverages
the great power of the VBA programming language to create the industry’s
state-of-the-art tool that has:
·
user-defined
functions (UDFs)
·
automated processes (macros)
·
rich user interaction via menus and
dialog boxes
·
access to Excel’s main menu “the
Ribbon”
· calculation engine optimized for speed
· comprehensive context-sensitive help including “Help on this function” in Excel’s standard function dialog box.
Related Topics