旧版 VBA 解决方案无法在 Office 2007 中运行

发布于 2024-07-18 07:47:12 字数 296 浏览 5 评论 0原文

各位,

基于 VBA 的现有系统安装在装有 Office 2007 的计算机上,但它不起作用,我面临的问题是:

  1. PowerPoint 加载项 (.PPA) 不再能够创建快捷菜单中的自定义按钮,Office 2007 是否更改了命令栏名称?

  2. (用 Wix 编写)没有像在 Office 2003 中那样安装 XLStart 文件夹中的文件,Office 2007 是否为 XLStart 使用了新名称或其他机制?

非常感谢任何有关如何解决上述问题的建议

Folks,

An existing system that was based on VBA was installed on a machine that has Office 2007 and it didn't work, the issues I faced are :

  1. A PowerPoint Add-in (.PPA) is no longer able to create the custom buttons in the shortcut menu, did Office 2007 change the commandbar names ?

  2. The MSI (written in Wix) didn't install the files in XLStart folder as it was doing so in Office 2003, did Office 2007 use a new name for XLStart or another mechanism ?

Any advice on how to troubleshoot the issues above is highly appreciated

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

山田美奈子 2024-07-25 07:47:12

对于第一个问题,我认为您将陷入修改加载项以与功能区配合的困境。

对于第二个问题,我怀疑启动位置是硬编码的。 如果是这种情况,请尝试写入 Excel.Application.StartupPath(如果从 PowerPoint 执行此操作,则需要设置对 Excel 的引用。)

For issue one, I think you are going to be stuck modifying the add-in to cooperate with the ribbon.

For issue two, I suspect that the start up location was hard coded. If that is the case, try writing to Excel.Application.StartupPath (You will need to set a reference to Excel if you are doing this from PowerPoint.)

临风闻羌笛 2024-07-25 07:47:12

您是否确保您使用的是受信任的位置或经过认证的项目?

http://office.microsoft.com/en-us/help/HA100319991033。 aspx

http://support.microsoft.com/kb/206637

Have you ensured that you are using a trusted location or a certified project?

http://office.microsoft.com/en-us/help/HA100319991033.aspx

http://support.microsoft.com/kb/206637

贩梦商人 2024-07-25 07:47:12

关于第1点:

我们理解其意图是
为您定制右键
具有可导航的自定义操作的菜单
通过应用程序并执行
各种任务,但是,右键单击
菜单创建和功能不是
Power Point 2007 中的一项功能。
目前没有升级路径
以前的 PowerPoint 解决方案
有自定义右键菜单
功能。 所有之前的电源
使用此点解决方案
功能需要实现
将 Ribbon 添加到他们的解决方案中
推动用户选择。

http://blogs.msdn.com/acoat/archive/2008/05/16/unable-to-customise-context-menus-in-powerpoint-2007.aspx

On point 1:

We understand that the intention is
for you to customize the right-click
menus with custom actions to navigate
through the application and perform
various tasks, however, right-click
menu creation and functionality is not
a feature in Power Point 2007. There
is currently no upgrade path for
previous Power Point solutions that
have customized right click menu
functionality. All previous Power
Point solutions using this
functionality will need to implement
the Ribbon into their solution to
drive user choices.

http://blogs.msdn.com/acoat/archive/2008/05/16/unable-to-customise-context-menus-in-powerpoint-2007.aspx

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文