Tag Archives: addin

Excel 2013 Inquire Addin improved IQ

In my previous blog post I complained that the Excel 2013 INQUIRE addin showed every single formula in A1 style, which is useless for recognising blocks of identical formulas. So I’ve now done something about that – I am making available … Continue reading

Posted in Excel/VBA, Productivity, Risk | Tagged , , , | 6 Comments

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

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

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

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