Monthly Archives: July 2012

String fuzzy matching in VBA and VB.Net

This describes how I speeded up a slow VBA string similarity function by first optimising the VBA and then migrating to VB.Net with Excel-Dna. If you’re a follower of Charles Williams’ FastExcel blog, none of this will be new to … Continue reading

Posted in Excel/VBA, ExcelDna, Productivity | Tagged , , , , , , , , , , | 5 Comments

Open Source Data Visualisation Add-in includes Treemap

In answering a question on the Excel-L list, I discovered Fabrice Rimlinger’s Open Source Excel addin for data visualisation. Although it’s called Sparklines for Excel, it has more than that, and the code is GNU public domain.

Posted in Excel/VBA | Tagged , , , , , , | Leave a comment