The description I am writing a couple of Excel UDFs in COM Servers. I'd like to get the standard help (Insert Function dialog) that you get when you press fx. Yes, I can see my COM Server listed in among the Category drop down, but I also see Equals, GetHashCode, GetType, and ToString (which are fairly undesirable to expose to the Exc...
I have a class that Im using for userdefined functions in Excel. The classlibrary is installed and available as an Automation object. I have no problems creating functions with one or more parameters. And no problems return arrays and 2 dimensional arrays as results. However Im trying to setup a function that can take variable paramete...
I created the following automation addin: namespace AutomationAddin { [Guid("6652EC43-B48C-428a-A32A-5F2E89B9F305")] [ClassInterface(ClassInterfaceType.AutoDual)] [ComVisible(true)] public class MyFunctions { public MyFunctions() { } #region UDFs public string ToUpperCase(str...