OverviewOverview\Development

Development

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.