Many readers will already be aware of the Operis Analysis Toolkit or OAK, the Excel plug-in that assists in building, analysing and editing complex spreadsheets. The OAK plug-in functions as a core part of Excel, integrating with the Excel ribbon interface.
Excel’s ribbon interface provides quick [...]
One of the lesser-known features included in the Operis Analysis Toolkit (OAK) is its ability to integrate into automated Excel workflows thanks to VBA. Yes, OAK’s features are conveniently accessible via the Excel ribbon interface but some workloads benefit substantially from macro automation, especially where [...]
