Category Archives: ExcelDna

Migrating an Excel VBA Add-in to a VB.Net XLL with Excel-Dna: update

This document has now grown to a 51 page tutorial.  Comments and corrections are requested. http://www.sysmod.com/vba-to-vb.net-xll-add-in-with-excel-dna.pdf I am providing a free addin QualifyVBACode. It takes the VBProject in a workbook and qualifies the xl constants with their enum types, and … Continue reading

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

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

Migrating Excel VBA Add-in to VB.Net, ExcelDNA, NetOffice

I have updated my previous post on migrating an addin with this 15-page Word document listing some of the things that kept me editing and debugging for two weeks on a 13,000  VBA LOC addin. I hope some of these … Continue reading

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

VB.Net addin for Excel with UserForms using ExcelDNA

The next installment of my experience in migrating an add-in to ExcelDna is now updated (4-May) at:  Migrating Excel VBA Add-in to VB.Net, ExcelDNA, NetOffice This builds on the documents in the previous posts: Getting Started with VB.Net using ExcelDNA.docx … Continue reading

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

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