Tag Archives: VB.Net

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

From VBA to VB.Net using ExcelDna

This is a collection of links for learning about VB.Net and ExcelDna. Firstly, here are my two documents: a collection of resources and a worked example of migrating an addin to VB.Net Getting Started with VB.Net using ExcelDNA.docx Practice project … Continue reading

Posted in Excel/VBA, ExcelDna | Tagged , , | 9 Comments