64位Office中的32位ActiveX控件 [英] 32-bit ActiveX control in 64-bit Office
问题描述
我们有一个旧的Excel VBA插件，它使用了一个ccrp计时器控件。计时器用于从另一个系统中提取数据。
我们的一些用户现在开始使用64位计算机，我们发现这个32位activeX控件不会在64位办公室工作。
到目前为止，我们一直建议人们安装32位版本的Office，但从长远来看，这不是一个真正可以接受的解决方案，所以我最好的解决方法是什么？
似乎没有64位版本的ccrp计时器。任何人都可以推荐一个32位和64位版本的好（最好是免费）等价物吗？
注意它并不一定需要是高精度计时器。我只需要每隔几秒左右检查一次新数据。
我可以在Excel中使用内置的计时器功能，但是我们已经远离多年前了。我不记得细节，但我认为是因为计时器事件的问题有时会被遗漏导致一切都停止更新。
有没有办法将控件加载到一个单独的进程，并将消息发送到Excel？
有没有办法创建一个封装32位控件功能的64位控件？
还有其他任何建议吗？
嗨Phil，
ccrp时间控件是否免费你能得到它的源代码吗？如果你能得到源，我认为你可以重写其中的函数并编译为64位。
据我所知，第三部分ActiveX控件和加载项无法工作使用64位版本的Office，您可以在Microsoft Office网站上查看此文章：
http://office.microsoft.com/en-us/word-help/choose-the- 32位或64位版本的microsoft-office-HA010369476.aspx
>>有没有办法将控件加载到一个单独的进程中，并将消息发送到Excel？
有没有办法创建一个封装32位控件功能的64位控件？
根据我的经验，没有办法让它和很难深入研究兼容的问题。
希望这会对你有所帮助。
问候，
 
We have an old Excel VBA addin that makes use of a ccrp timer control. The timer is used to pull data in from another system.
Some of our users are now starting to use 64-bit machines, and we have discovered that this 32-bit activeX control will not work within 64-bit office.
So far, we have been recommending that people install the 32-bit version of Office, but this is not really an acceptable solution in the long term, so what is my best approach to fixing this?
There doesn't appear to be a 64-bit version of the ccrp timer. Can anyone recommend a good (preferably free) equivalent that comes in 32 and 64-bit versions?
Note that it doesn't really need to be a high-precision timer. I just need to check for new data every few seconds or so.
I could use the in-built timer functions in Excel, but we moved away from that many years ago. I can't remember the details but I think it was because of problems with the timer events sometimes being missed causing everything to stop updating.
Is there a way of loading the control into a separate process, and send messages to Excel?
Is there a way of creating a 64-bit control that encapsulates the functionality of the 32-bit control?
Any other suggestions?
Hi Phil,
Is the ccrp time control free and can you get the souce code of it? If you can get the souce, I think you can rewrite the functions in it and compiled to be 64bit.
As far as I know, 3rd part ActiveX controls and add-ins can not work with the 64bit version of Office, you can check this article on Microsoft Office site:
>> Is there a way of loading the control into a separate process, and send messages to Excel?
Is there a way of creating a 64-bit control that encapsulates the functionality of the 32-bit control?
Based on my experience, there does not exist the way to make it and it is hard to dig into the compatible problems.
Hope this helps you.
Regards,
这篇关于64位Office中的32位ActiveX控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
