how to use URL instead of chm file for help

Dec 21, 2011 at 7:14 PM

chm file works fine. Now we want to switch to online document.

I tried replacing chm with URL, does not work

[ExcelFunction(Description = "My function desc", Category = "MyAddIn", HelpTopic = ""]

public static object MyUDF(string param1)

When I select MyAddIn category, select MyUDF from "insert function" dialog, click "Help on this function", it says "help not found"

so how to use URL instead of chm for Excel function?


Dec 21, 2011 at 7:19 PM

As far as I know Excel only support help system topics, and not URLs for the function wizard help.


Dec 21, 2011 at 8:30 PM

thanks.   So there is no workaround like Can I capture click event on "Help on this function" and display URL?

Dec 21, 2011 at 8:41 PM

Natively Excel has no such support.

I'm vaguely planning future work on customising the function wizard further, but this would be tricky stuff - so you shouldn't hold your breath.


Dec 25, 2011 at 9:57 PM

Ah, I see Excel 2010 did add support for this. However, the way Excel-DNA processed the HelpTopic string prevents this from working in the current version.

So in the next version of Excel-DNA (v. 0.30) the web url help topics will work under Excel 2010.