使用其他应用程序的资源？ [英] Resource for Working With Other Applications?

问题描述

Hello All，

Hello All,

我已经完成了我用PowerPoint VBA编写的程序的第一个版本，但是想要使用Excel工作簿充当"配置" ; PowerPoint产品的来源。  我相信这对最终用户来说比在PowerPoint幻灯片中保留
所有内容或让他们深入研究实际模块以进行更改更容易。  之前从未在应用程序之间工作过。  有人可以指向我在线或印刷资源我应该查看吗？

I have finished the first release of a program I've written in PowerPoint VBA but want to use an Excel workbook to act as the "Configuration" source for the PowerPoint product.  I believe this will be easier to use for the end user than keeping everything in PowerPoint slides or asking them to delve into the actual modules to make changes.  I have never worked between applications before.  Could someone point me towards a resource either online or in print that I should look into?

谢谢，

G

推荐答案

您有2个选择：

You have 2 options:

• 早期绑定

这是通过转到工具 - >来实现的。引用并选择"Microsoft Office 14.0对象库"。选项。（版本号可能更高）这将允许
你使用IntelliSense，如果你不完全适合编写VBA for Excel，那就更好了。

This is achieved by going to Tools -> References and selecting the "Microsoft Office 14.0 Object Library" option. (version number may be higher) This is will allow you to make use of IntelliSense which is much better if you're not completely comfortable with coding VBA for Excel.

• 晚期绑定

这是通过创建对象来完成的在执行时，使用 CreateObject（） 方法，这将是
不 在VBE中启用IntelliSense，因为没有参考已设置为该库。

This is done by creating the object at execution time, using the CreateObject() method, this will not enable IntelliSense in the VBE because no reference has been set to that library.

这篇关于使用其他应用程序的资源？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！