Managed Automation Add-ins

I’ve been thinking more about calling unmanaged XLL UDFs from managed code than about managed automation add-ins lately, but an automation add-in issue came up the other day, and I thought I’d throw it out there. If you want to build managed UDFs without going to the extreme of managed XLLs, you have a couple…

4

Excel Interop Types in Shimmed Automation Add-ins

In my previous posts on shimming Excel automation add-in UDFs, I’ve used simple examples where the methods tended to take and return standard types such as doubles and ints. Someone asked a question recently – what about Excel types as parameters? In other words, how do you write the shim for a method that takes…

6