旧版 VBA 解决方案无法在 Office 2007 中运行
各位,
基于 VBA 的现有系统安装在装有 Office 2007 的计算机上,但它不起作用,我面临的问题是:
PowerPoint 加载项 (.PPA) 不再能够创建快捷菜单中的自定义按钮,Office 2007 是否更改了命令栏名称?
- (用 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 :
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 ?
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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
对于第一个问题,我认为您将陷入修改加载项以与功能区配合的困境。
对于第二个问题,我怀疑启动位置是硬编码的。 如果是这种情况,请尝试写入 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.)
您是否确保您使用的是受信任的位置或经过认证的项目?
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
关于第1点:
http://blogs.msdn.com/acoat/archive/2008/05/16/unable-to-customise-context-menus-in-powerpoint-2007.aspx
On point 1:
http://blogs.msdn.com/acoat/archive/2008/05/16/unable-to-customise-context-menus-in-powerpoint-2007.aspx