Hooking up a CHM file to xl2007

[Rasm]

I looking for an example of how to connect a CHM (Help file) to my XLAM add-in - any example showing how to do this would be most appreciated.

[Admin]

Hi Rasm,

have a look at Ken's post here Using Help in Your Applications (http://www.excelguru.ca/content.php?166)

[Rasm]

Very cool article

[Rasm]

This worked great - here is the code to bring up the entire CHM file



Public Sub ReadHelpFile(Language)
'http://www.excelguru.ca/content.php?166
Dim MyHelpFile As String
MyHelpFile = ThisWorkbook.Path & "\NameOfFile.chm"
If Dir(MyHelpFile, vbNormal) <> "NameOfFile.chm" Then
Astr = MyHelpFile
Call Message109(Language, Astr)
Exit Sub
End If
Application.Help MyHelpFile
End Sub