Category Archives: ExcelDna

Extend Excel: London 18 Oct

Posted on Jul 23, 2018 by Patrick O'Beirne, Excel/VBA developer

Charles Williams is organising  a conference in London on October 18th, 2018. I’ll be there! This is a rare chance to meet leading developers from all over the world and hear directly from MS on Excel Extensibility. Expect to be … Continue reading →

Posted in Excel/VBA, ExcelDna, Open Source, Productivity, Research, Software Quality, Software Testing, Uncategorized | Tagged , | Leave a comment

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

Posted on Nov 6, 2012 by Patrick O'Beirne, Excel/VBA developer

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 , , , | 17 Comments

String fuzzy matching in VBA and VB.Net

Posted on Jul 27, 2012 by Patrick O'Beirne, Excel/VBA developer

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

Posted on May 4, 2012 by Patrick O'Beirne, Excel/VBA developer

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

Posted on Mar 21, 2012 by Patrick O'Beirne, Excel/VBA developer

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

Posted on Feb 6, 2012 by Patrick O'Beirne, Excel/VBA developer

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