VBA宏插件 [英] VBA macro to plugin

查看:161
本文介绍了VBA宏插件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有这个宏:  https://social.msdn.microsoft.com/Forums/Lync/en-US/56a5ff42-2167-4fda-a3ef-51545970c94d/vba-beforeitemmove-event-create -rule-to-always-move-sent-mail-to-its-folder?forum = outlookdev


我想将其应用于域中的许多客户端。我认为唯一的方法是将其转换为插件,然后通过GPO推送它。有没有其他选择?



如何将VBA宏转换为Outlook插件?

解决方案

Hello Kadam,


您说得对,VBA宏不是为将您的解决方案分发到多台计算机而设计的。这正是COM加载项的设计目标。


没有转换器可以自动完成这部分工作。请参阅

演练:创建您的第一个VSTO加载项Outlook
快速入门。
本演练演示如何为Microsoft Office Outlook创建VSTO加载项。


您可以考虑创建VB。基于.NET的Outlook加载项。在这种情况下,您将避免语言翻译问题。您可以找到

将代码从VBA转换为Visual Basic .NET
文章很有帮助。 p 在将Microsoft Office解决方案从Visual Basic for Applications(VBA)转换为Visual Basic .NET时需要考虑的问题。提供其
差异的一般概述,然后使用Word和Excel中的示例来描述如何使用Visual Studio工具为Microsoft Office System转换代码。


I have this macro: https://social.msdn.microsoft.com/Forums/Lync/en-US/56a5ff42-2167-4fda-a3ef-51545970c94d/vba-beforeitemmove-event-create-rule-to-always-move-sent-mail-to-its-folder?forum=outlookdev

I want to apply that to many clients in domain. I think the only way to do so is to convert it into plugin and then pushing it thanks to GPO. Is there any alternative?

How to convert VBA macro to outlook plugin?

解决方案

Hello Kadam,

You are right, VBA macros are not designed for distributing your solution to multiple machines. That is exactly what COM add-ins were designed for.

There is no converters that can do this part of work for you automatically. See Walkthrough: Creating Your First VSTO Add-In for Outlook to get started quickly. This walkthrough shows you how to create a VSTO Add-in for Microsoft Office Outlook.

You may consider creating a VB.NET based Outlook add-in. In that case you will avoid language translating issues. You may find the Converting Code from VBA to Visual Basic .NET article helpful. It presents issues to consider when converting your Microsoft Office solutions from Visual Basic for Applications (VBA) to Visual Basic .NET. Provides a general overview of their differences, and then uses examples from Word and Excel to describe how you can use Visual Studio Tools for the Microsoft Office System to convert your code.


这篇关于VBA宏插件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆