Ever wanted to determine which OBDC drivers are installed on a PC, maybe SQL Server specific OBDC drivers? Find out how easy it can be done via VBA.

ALWAYS Use Option Explicit, Work with Arrays, Not With Ranges, Switch off properties during macro execution, Use VB constants when available, Avoid using SELECT or ACTIVATE, Always define and set references to all Workbooks and Sheets, Use descriptive variable naming, Document Your Work, Error Handling, Never Assume The Worksheet, Avoid using ActiveCell or ActiveSheet in Excel, WorksheetFunction object executes faster than a UDF equivalent, Avoid re-purposing the names of Properties or Methods as your variables

Actuarial models one of the most common usages of Excel to build complex mathematical models and test them under various conditions.