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.


I am providing a free addin QualifyVBACode. It takes the VBProject in a workbook and qualifies the xl constants with their enum types, and prefixes ones like ActiveSheet with Application. The search/replace strings are in a XML key/value config file that you can edit. Of course, please read the ReadMe.txt file first after unzipping this (XLL, DNA, DLL, CONFIG) :


About these ads

About Patrick O'Beirne, spreadsheet auditor

Patrick provides consultancy and training in spreadsheet development, auditing / testing and model review; and the Excel addin XLtest
This entry was posted in Excel/VBA, ExcelDna and tagged , , , . Bookmark the permalink.

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

  1. Govert says:

    This is growing into a very nice and comprehensive guide – thanks for the effort, Patrick!
    (There is something wrong with the link to the document – the displayed text is correct, but when clicked on it goes to some ftp site.)

  2. Pedie Nz says:

    Is Excel-Dna used along with Visual Studio?
    Do i need to install this separately? is it cost involved?

    • sysmod says:

      It can be used with full VS. Or, VS Express, or SharpDevelop, both free.
      This is explained in the document. Try the exercises in order and come back with any questions that need more explanation.

  3. Pingback: Moving on from Excel VBA to another programming language - what to choose? - Page 2

  4. Pingback: Excel DNA for C# – First functions | Capricorn Excel

  5. Pingback: Question Calling Dot Net code directly from a custom Excel "=" function

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s