Monthly Archives: November 2012

Getting Cell data with VBA and C++: Benchmarking Excel 2013

There is a new kid on the block: Excel 2013. So its time to see how it shapes up for VBA performance against its predecessors. Along the way I will try to answer these questions:. How does Excel 2013 VBA … Continue reading

Posted in VBA, XLL | Tagged | 16 Comments

Multi-threading XLL functions – Evaluate fails

I have just about finished converting the first part of the FILTER.IFS function from VB6 to C++. This first part uses modified binary search routines to handle multiple kinds of criteria (EQ, GT, LT, GE, LE, NE with AND and … Continue reading

Posted in Calculation, XLL | 5 Comments