.chm Help Viewer

[bill]

All,

After fiddling around awhile I can now create an HTML Help file (.chm).
Unhappily, Excel (I am using 2003) opens it with an older Help Viewer.
How can I have Excel use the later viewer?

TIA,

Bill

 

[Guest]

Hello Bill,

After fiddling around awhile I can now create an HTML Help file (.chm).
Unhappily, Excel (I am using 2003) opens it with an older Help Viewer.
How can I have Excel use the later viewer?

I uploaded a sample for calling context-sensitive help at:
http://www.help-info.de/download/CHM_VBA_example/CHM_VBA_example.zip

Unzip the files in a local temp folder on drice C:
Set Macros in EXCEL to allowed
Click the button to show help

There is a very active English-speaking newsgroup for help authoring. A
second group for the topic "help authors" occupiedly with the development of
help systems in applications which are developed with a Visual studio.

news://msnews.microsoft.com/microsoft.public.helpauthoring
news://msnews.microsoft.com/microsoft.public.vstudio.helpauthoring

HTH
Best regards
Ulrich Kulle
**************************
http://www.help-info.de
**************************

 

[dgp]

I have an Add-In with several user-defined functions. The documentation
is in a chm help file located in the same directory. To set the
function options and define the context sensitive help tags I have the
following code for each function:

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

These commands for each function are in a subroutine. The subroutine is
only run once when creating the final version of the Add-in file. The
context sensitive help opens from the formula pallete in a single paned
window - without the index, search, and table of contents tabs. I don't
think this behavior can be changed. For context senstive help this is
fine with me since it shows the user only the information for the
function they are currently trying to use in a simple window interface.

I also provide a menu item in the Help menu for user to access the full
help file - with the index, search, and table of contents tabs. The
following code is used to open the file:

Sub ShowEngFunctHelp()
' Show help using API function (Using Application.Help does not work
correctly)
Dim Result
Result = HtmlHelp(0, ThisWorkbook.Path & "\EngFunctHelp.chm", &HF,
ByVal 1000)
If Result = 0 Then MsgBox "Cannot display Help", vbCritical,
"Eng-Funct Help"
End Sub

"1000" is the contextID for the first page of the help file containing
the name, logo, etc for the Add-in.

Hope this helps,
Dave Parker