Add in for MS office

[simon]

I would like to create addIn for outlook,word and excel.

That is a new button on menu bar. When user open a new mail message or word
document or excell document, the button shows on menu bar, and when user
clicks this button, I read the projects of the current user from the
database and when user select the project,
the opened document (which is a mail message, word file or excell file) is
saved to the database with the selected project ID.

How can I do that in VB.net. What kind of project I should create?
Any example or ideas?

Thank you,
Simon

 

[Ken Tucker [MVP]]

Hi,

There is wizard for creating office add ins. Create a new project,
Other projects, extensibility projects, and select shared add in.

Ken
----------------------
I would like to create addIn for outlook,word and excel.

That is a new button on menu bar. When user open a new mail message or word
document or excell document, the button shows on menu bar, and when user
clicks this button, I read the projects of the current user from the
database and when user select the project,
the opened document (which is a mail message, word file or excell file) is
saved to the database with the selected project ID.

How can I do that in VB.net. What kind of project I should create?
Any example or ideas?

Thank you,
Simon

 

[simon]

Thank you very much, taht is what I need.

Do you have some simple example for start, maybe link to it or some
recommended book?
Or can you give me some instruction to achive the required functionallity?

Thank you,
Simon

 

[Ken Tucker [MVP]]

Hi,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office06062002.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q302896

Ken
------------------
Thank you very much, taht is what I need.

Do you have some simple example for start, maybe link to it or some
recommended book?
Or can you give me some instruction to achive the required functionallity?

Thank you,
Simon

 

[simon]

thank you, I belive it will be enough to finish my job in VB.NET.
I have one simple question:

I created before this add in in VB6. It works perfect only problem is, that
the button is added in all office programs, but I would like, that it's
added only to Outlook menu bar.

I use this sintaks to create button:

Private Sub myOlInspectors_NewInspector(ByVal Inspector As
Outlook.Inspector)
'button will show when user open the email message
If Inspector.CurrentItem.MessageClass = "IPM.Note" Then
'should I check here if application is outlook than create button
Set MyButton = Inspector.CommandBars.Item("Menu
Bar").Controls.Add(msoControlButton, , , , True)
With MyButton
.Caption = "CPU"
.OnAction = "!<myaddin.connect>"
End With
End If

End Sub

Why this button is shown on my menu bar also when I open word application?
If it helps, I can send all sintkas of my program.
maybe I should remove button on disconection or something similar?

Private Sub AddinInstance_OnDisconnection(ByVal RemoveMode As
AddInDesignerObjects.ext_DisconnectMode, custom() As Variant)
'I should put some remove function here?
Set myOlApp = Nothing
Set myOlInspectors = Nothing
Set MyButton = Nothing
End Sub

Thank you,
Simon