我发现了一个Excel配置错误：无法获取OLEObject类的Object属性(I found an Excel configuration error: Unable to get the Obje

我发现了一个Excel配置错误：无法获取OLEObject类的Object属性(I found an Excel configuration error: Unable to get the Object property of the OLEObject class)

我想知道OLEObject的性质和OLEObject所在的位置。 我不是VBA程序员，但我办公室的VBA开发人员发现了错误消息，并且她无法在她的计算机上运行有问题的Excel VBA程序。 该程序完全在另一台机器上运行。

I want to know about OLEObject's nature and where OLEObject is located. I'm not a VBA programmer, but an VBA developer in my office found that error message, and she can't run the Excel VBA program in question on her machine. This program runs completely in another machine.

最满意答案

我首先要确保在她的机器上启用ActiveX控件 。 根据我的经验，这是VBA程序在一台机器上运行但不在另一台机器上运行的典型原因。

你也可以：

首先尝试使用.Activate激活对象 尝试通过索引而不是名称来引用对象

I would first ensure ActiveX controls are enabled on her machine. This has been, in my experience, the typical cause when a VBA program will run on one machine but not another.

You could also:

Try activating the object first by using .Activate beforehand Try referencing the object by its index rather than name