Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programmatically close help file before Excel closes?
Using Excel XP.
I am having the following problem. Have a userform that can launch a .chm help file with the following code: 'this API function is for displaying the help file Private Declare Function HtmlHelpTopic Lib "hhctrl.ocx" _ Alias "HtmlHelpA" _ (ByVal hWnd As Long, _ ByVal lpHelpFile As String, _ ByVal wCommand As Long, _ ByVal dwData As String) As Long Sub ShowHtmlHelp(ByVal strHelpFile As String, _ Optional ByVal strHelpPage As String) Const HH_DISPLAY_TOPIC As Long = &H0 On Error Resume Next HtmlHelpTopic 0&, strHelpFile, HH_DISPLAY_TOPIC, strHelpPage End Sub Sub ShowHelp() Dim AddinFolder As String AddinFolder = _ Left(ThisWorkbook.FullName, Len(ThisWorkbook.FullName) - 21) ShowHtmlHelp AddinFolder & "\Test.chm" End Sub This works all fine. The problem is when the help file is loaded, the userform gets closed and then Excel gets closed. Excel then crashes. So I have to make sure that the help file gets closed before Excel closes. Perhaps I need an API function here, but I can't figure it out. Thanks for any advice. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do all excel files close when one closes? | Excel Discussion (Misc queries) | |||
why do all excel files close when one closes? | Excel Discussion (Misc queries) | |||
when i insert word art in excel sheet excel file closes automatica | Excel Discussion (Misc queries) | |||
Excel closes all open apps when i close one | Excel Discussion (Misc queries) | |||
Excel 2003 File Closes In 2000 | Links and Linking in Excel |