Registering an add-in with UDFs

[NiekOtten]

Hi all,

Windows 7, Excel 2010

I have an add-in with UDFs. I want explanation of the function arguments in the function wizard and also be able to click for Help in the wizard.
So I register the functions like this:


Application.MacroOptions macro:=Range("afsfunctienaam")(i), _
Description:=Range("afsfunctiebeschrijving")(i), _
Category:=Range("afsfunctiecategorie")(i), _
HelpContextID:=Range("afshelpcontextid")(i), _
HelpFile:=HelpPad, _
argumentdescriptions:=Sheets("afsnederlands").Range(Paramtabel)

Where Param is the address of an array with argument descriptions, as text (like “A1:A4”).
If I run the xlsm file, it works fine.
But if I load the xlam file in the add-ins dialog, the path to the Help file seems to be lost; I get directed to Excel's general online Help. The explanation of the arguments still work. Probably because they are already in the registry. But shouldn't the Help path be held in the registry as well?

Thanks,

Kind regards,

Niek Otten

 

[Zack Barresse]

Hi Niek,

What is the HelpPad variable? It should be a path to a CHM file (not sure about HLP files) and the HelpContextID should be an integer value. This won't work in Excel 2003, as I understand it, but it should work in 2007+.

What do you use to create your help files? If there is a good freeware version I can test as well.