Excel VBA“CreateObject”不适用于Office 2010 Windows 7虚拟环境

问题描述

我有一个C＃类构建为DLL，我通过"CreateObject"引用并在vba模块中使用。

我得到了一个： 运行时错误'429'：  ActiveX组件无法创建对象" b
相同的代码适用于Office 2007 Excel（即使在Windows 7上），但它不适用于虚拟机上的Office 2010 Excel。 （不是CTR版本）

为了记录，我在我拥有的机器上尝试了相同的设置和不同的排列：

它适用于Windows的同一个vmware 7当它是Excel Office 2007时。

它可以在PC上运行（虽然有XP）Excel Office 2010.

它不适用于vmware Windows 7 Office 2010 。$
...因此我很困惑。

任何帮助/潜在客户都将不胜感激！

谢谢，

Kim

---

Kim

解决方案

I have a C# class built as a DLL which I reference and use within a vba module via a "CreateObject"
I get a:  Run-time error '429':  ActiveX component can't create object"
The same code works for Office 2007 Excel (even on Windows 7) however, it does not work for Office 2010 Excel on a virtual machine. (not CTR version)
For the record, I have tried the same set up with different permutations on the machines I have:
It DOES work on the same vmware for Windows 7 when it is Excel Office 2007.
It DOES work on a PC (though that has XP) Excel Office 2010.
It DOES NOT work for vmware Windows 7 Office 2010.
...thus I am puzzled.
Any help/leads would be greatly appreciated!
Thanks,
Kim

---

Kim

解决方案

这篇关于Excel VBA“CreateObject”不适用于Office 2010 Windows 7虚拟环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！