Invoking Native Excel UDFs From Managed Code (Pt2)

In my previous post, I looked at how to build a VSTO add-in that invokes native XLL UDFs via the Excel COM OM (specifically, Application.Run). In this second part, I’ll look at the same managed client calling the same XLL UDFs via the Windows API instead of Excel’s COM OM, specifically using LoadLibrary and GetProcAddress….


Invoking Native Excel UDFs From Managed Code (Pt1)

As part of a little ongoing investigation, I wanted to communicate between a managed add-in and a native XLL UDF. As I was writing this up, it turned out to be a much longer post that I planned, so I’ve split it into two parts (I’ll post the second part in the next week or…


Building an Excel XLL in C/C++ with VS 2008

As part of a little investigation I’m doing at present, I needed to build some simple native XLLs for testing purposes. This was the first time I had a need to build XLLs since the Excel XLL SDK was updated back in September. The updated Excel 2007 XLL SDK is available for free download here….