Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?

Hi Matthew

The below will take you in the right direction...You can try the below code
to initiate in open event..which will identify the Help Control and add a new
button named "New Help" and assign that to a Macro which exists in the
add-in. Try and feedback


Dim cbMainMenuBar As CommandBar
Dim cbcCutomMenu As CommandBarControl

Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
Set cbcCutomMenu = cbMainMenuBar.Controls("Help")
With cbcCutomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "New Help"
.OnAction = "Macro1"
End With


If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?

Jacob - it looks like what you have there is just how to add another help
button to the menu - I want to know how to merge help documentation into the
existing help system so that when my add-in is inside someone's excel
workbook, they can get help on the functionality just like they would any
other Excel function.


"Jacob Skaria" wrote:

Hi Matthew

The below will take you in the right direction...You can try the below code
to initiate in open event..which will identify the Help Control and add a new
button named "New Help" and assign that to a Macro which exists in the
add-in. Try and feedback


Dim cbMainMenuBar As CommandBar
Dim cbcCutomMenu As CommandBarControl

Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
Set cbcCutomMenu = cbMainMenuBar.Controls("Help")
With cbcCutomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "New Help"
.OnAction = "Macro1"
End With


If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?

Sorry; I havent tried any of those. Let us wait for another response

PS:Hope you are aware of calling a help topic using Application.Help

If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Jacob - it looks like what you have there is just how to add another help
button to the menu - I want to know how to merge help documentation into the
existing help system so that when my add-in is inside someone's excel
workbook, they can get help on the functionality just like they would any
other Excel function.


"Jacob Skaria" wrote:

Hi Matthew

The below will take you in the right direction...You can try the below code
to initiate in open event..which will identify the Help Control and add a new
button named "New Help" and assign that to a Macro which exists in the
add-in. Try and feedback


Dim cbMainMenuBar As CommandBar
Dim cbcCutomMenu As CommandBarControl

Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
Set cbcCutomMenu = cbMainMenuBar.Controls("Help")
With cbcCutomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "New Help"
.OnAction = "Macro1"
End With


If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?

Does anyone know how to do this?

"Jacob Skaria" wrote:

Sorry; I havent tried any of those. Let us wait for another response

PS:Hope you are aware of calling a help topic using Application.Help

If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Jacob - it looks like what you have there is just how to add another help
button to the menu - I want to know how to merge help documentation into the
existing help system so that when my add-in is inside someone's excel
workbook, they can get help on the functionality just like they would any
other Excel function.


"Jacob Skaria" wrote:

Hi Matthew

The below will take you in the right direction...You can try the below code
to initiate in open event..which will identify the Help Control and add a new
button named "New Help" and assign that to a Macro which exists in the
add-in. Try and feedback


Dim cbMainMenuBar As CommandBar
Dim cbcCutomMenu As CommandBarControl

Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
Set cbcCutomMenu = cbMainMenuBar.Controls("Help")
With cbcCutomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "New Help"
.OnAction = "Macro1"
End With


If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?