Convert OL VBA - Code into com add-in "Joerg Meier" <joergNEWS[ at ]gmx.com> 5/21/2006 1:04:03 PM Hi, i am Using MS Outlook 2003. I wrote an Outlook-VBA to move sent emails from the personal sent box to the group-account sent box, if sent on behalf of it. Now I want that everybody in our department uses this vba. But I cannot go to every staff, open outlook, copy the code and disable makro-security. Too much staff. So somebody in the MS Outlook Newsgroup told me, that I have to do this with a COM ADD-IN. Shit. I really know nothing about COM ADD-INs. Is there a possibility to simply convert the VBA-Code into a COM ADD-IN? How do I register the COM ADD-IN for every user? Thx Joerg

Re: Convert OL VBA - Code into com add-in Michael Bauer <mb[ at ]mvps.org> 5/21/2006 5:12:07 PM Am Sun, 21 May 2006 15:04:03 +0200 schrieb Joerg Meier: Joerg, please see my answer in de.outlook. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- [Quoted Text] > Hi, > > i am Using MS Outlook 2003. > > I wrote an Outlook-VBA to move sent emails from the personal sent box to the > group-account sent box, if sent on behalf of it. > Now I want that everybody in our department uses this vba. > > But I cannot go to every staff, open outlook, copy the code and disable > makro-security. Too much staff. > > So somebody in the MS Outlook Newsgroup told me, that I have to do this > with a COM ADD-IN. > > Shit. I really know nothing about COM ADD-INs. > > Is there a possibility to simply convert the VBA-Code into a COM ADD-IN? > How do I register the COM ADD-IN for every user? > > Thx > > Joerg

Re: Convert OL VBA - Code into com add-in dave.wayne[ at ]gmail.com 5/31/2006 12:59:19 AM If you could post the answer here as well, I am sure lots of people would benifit from your knowledge

Re: Convert OL VBA - Code into com add-in Michael Bauer <mb[ at ]mvps.org> 5/31/2006 5:14:03 AM Am 30 May 2006 17:59:19 -0700 schrieb dave.wayne[ at ]gmail.com: In the German group he told that he wants a VBA project to be used by every member of a specific user group. Using a COM Add-In for that scenario was only one part of my answer. The other suggestions were to use Custom Forms, or to copy that VBA project into each user profile. Then he asked for a tool that converts the VBA project into a COM Add-In because he don´t want to learn VB. This was my answer then: You can do the migration from VBA to VB almost 1:1. All you need is Visual Basic 6 or an Office Developer Edition for being able to create ActiveX DLLs. So the "tool" you´re asking for is a proper developer environment. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- [Quoted Text] > If you could post the answer here as well, I am sure lots of people > would benifit from your knowledge