我发现一个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.

推荐答案

我首先要确保

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.

您还可以:

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

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

这篇关于我发现一个Excel配置错误:无法获取OLEObject类的Object属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！