![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#4
|
|||
|
|||
![]()
Deployment of Outlook VBA macros is not recommended and is not a best
practice. You are strongly urged to use a COM addin if you intend to deploy your code. There's information at www.outlookcode.com on deploying your code as Outlook VBA, if you insist on ignoring best practices. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Andreich71" wrote in message ... Thanks. i really found several examples. This is my compilation: ------------------------------------------- Option Explicit Public WithEvents oCBBCustom As Office.CommandBarButton Private Sub Application_Startup() Dim oCB As Office.CommandBar Dim oCBBTools As Office.CommandBarPopup Set oCB = Application.ActiveExplorer.CommandBars("Standard") oCB.Reset Set oCBBCustom = oCB.Controls.Add(msoControlButton, 1, , oCB.Controls.Count, True) With oCBBCustom .TooltipText = "my_Button" .BeginGroup = True .Style = msoButtonIcon .Picture = LoadPicture("c:\k.bmp") .Enabled = True .Visible = True End With End Sub Private Sub oCBBCustom_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean) Dim newItem As Variant Set newItem = Application.CreateItemFromTemplate("c:\wywo\MyForm .oft") newItem.Display Set newItem = Nothing End Sub ------------------------------------------- And it works fine on machine where I added this code manually in Visual Basic Editor. But I wonder what is the best way to distribute this on a several machines? I need installation to be silent. If copying of VbaProject.OTM is a best way to do this? When i copy this file my script doesn't work and I have to copy outcmd.dat as well. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Button To Open Template - Outlook 2007 | garfong | Outlook and VBA | 7 | May 22nd 08 09:37 AM |
Outlook 2003 - Button to add body text to an OPEN email | Patrick Pirtle | Outlook and VBA | 5 | September 14th 07 03:15 PM |
OFT Files won't open correctly - email instead of template | Tmuldoon | Outlook - Using Forms | 1 | April 23rd 07 09:48 PM |
How do i open a word template from within a contact in Outlook 200 | Mark | Outlook - Using Contacts | 3 | July 28th 06 08:48 PM |
Outlook 2000 - Button to run Macro then open Database | David C | Outlook and VBA | 1 | January 25th 06 03:44 PM |