Launching context-sensitive HTML Help for a Function in Excel Add-In

[kwong.joey]

Hi,
I built a Excel Add-in using VC++ 6.0 and had compiled my own HTML Help
..chm file. I would like to be able to provide context-sensitive help
for the functions I defined in the Add-in, so that when the user click
on the "Help on this Function" link in the Insert Function dialogue
box, the HTML Help viewer window will pop up.

I know this is possible if I use WinHelp file and pass the
[filename.hlp]![contextID] in the help_topic parameter in the Excel4()
Excel API macro in the C++ code. Is there an equivalent string I
should use for HTML Help?

Thanks,
J

 

[dgp]

In VBA you set the help path/file and context ID as a macro option.
This is only has to be done once when the file is created, as shown
below. I'm sorry but I'm not sure exactly how it is done for a VC++
add-in, but I hope this helps.

Application.MacroOptions Macro:="Air_visc", _
Description:="Viscosity of Air, lbm/(in*s)." _
HelpContextID:=1010, HelpFile:=ThisWorkbook.Path & _
"\EngFunctHelp.chm"

The ContextID numbers for each function are specified in the chm file.

Dave Parker

 

[kwong.joey]

Hi,
Thanks for your reply. Ideally I would like my solution to be done
inside c++ because my Excel Add-in will be distributed to many users.

Thanks again for your help; you have just showed me one more way of
getting things done.

J

In VBA you set the help path/file and context ID as a macro option.
This is only has to be done once when the file is created, as shown
below. I'm sorry but I'm not sure exactly how it is done for a VC++
add-in, but I hope this helps.

Application.MacroOptions Macro:="Air_visc", _
Description:="Viscosity of Air, lbm/(in*s)." _
HelpContextID:=1010, HelpFile:=ThisWorkbook.Path & _
"\EngFunctHelp.chm"

The ContextID numbers for each function are specified in the chm file.

Dave Parker

Hi,
I built a Excel Add-in using VC++ 6.0 and had compiled my own HTML Help
.chm file. I would like to be able to provide context-sensitive help
for the functions I defined in the Add-in, so that when the user click
on the "Help on this Function" link in the Insert Function dialogue
box, the HTML Help viewer window will pop up.

I know this is possible if I use WinHelp file and pass the
[filename.hlp]![contextID] in the help_topic parameter in the Excel4()
Excel API macro in the C++ code. Is there an equivalent string I
should use for HTML Help?

Thanks,
J