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 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) :
Patrick O'Beirne @ sysmod 
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.)
Thanks Govert, that was a paste problem – fixed!
Is Excel-Dna used along with Visual Studio?
Do i need to install this separately? is it cost involved?
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.
Pingback: Moving on from Excel VBA to another programming language - what to choose? - Page 2
Pingback: Excel DNA for C# – First functions | Capricorn Excel
Pingback: Question Calling Dot Net code directly from a custom Excel "=" function
Excellent guide. Thanks for creating it. I’m stuck on one bit though… In trying to debug a library by modifying the MyApp.vbproj.user file, I find that the contents of the file are completely different in my case from your example. Is this because I am using VS Express 2012? Appreciate it if you know what is different here. Thanks.
Can you post your vbproj.user file so I can see what’s different?
ShowAllFiles
That is the correct file, assuming the tags were removed by WordPress.
To post code, there are guidelines in
http://codex.wordpress.org/Writing_Code_in_Your_Posts
I’ll use the pre and /pre tags here to test it:
Program C:\Program Files\Microsoft Office\Office14\EXCEL.EXE CreateTOC.NET.xll ShowAllFilesAh, that test shows the pre tags did not help.
Try again, in Notepad I replaced all open angle brackets with ampersand lt semicolon
and right angle bracket with ampersand gt semicolon
<?xml version=”1.0″ encoding=”utf-8″?>
<Project ToolsVersion=”4.0″ xmlns=”http://schemas.microsoft.com/developer/msbuild/2003″>
<PropertyGroup Condition=” ‘$(Configuration)|$(Platform)’ == ‘Debug|AnyCPU’ “>
<StartAction>Program</StartAction>
<StartProgram>C:\Program Files\Microsoft Office\Office14\EXCEL.EXE</StartProgram>
<StartArguments>CreateTOC.NET.xll</StartArguments>
</PropertyGroup>
<PropertyGroup>
<ProjectView>ShowAllFiles</ProjectView>
</PropertyGroup>
</Project>
That worked. Must be an easier way to post literal markup in WordPress.
Pingback: My First Custom Excel Ribbon using Excel-DNA – Site Title
Pingback: My First Custom Excel Ribbon using Excel-DNA – Andy Sprague
Pingback: The Excel-DNA | kumbukumbu
I am stuck at the beginning. I have followed your guide to create TestFuncs dll in Visual Studio 2015 on Windows 10 for Excel 2019 64 bit. The xll loads into Excel but the UDF do not appear. I have no idea what I’m missing. Thanks for any help.