Excel ActiveX 调用中出现的错误代码 0x800A01A8 是什么？
我正在使用 LabVIEW 通过 ActiveX 接口与 Excel 进行交互。
由于某种原因，在成功写入电子表格一段时间后，我在尝试调用对范围执行某些操作的函数时收到此错误。
抱歉，这个问题太模糊了，但这是因为我实际上正在使用另一个工具包来处理 Excel 写入。
有人知道是否有 Excel ActiveX 调用的查找表吗？
谢谢
I am using LabVIEW to talk to Excel via its ActiveX interface.
For some reason after some time successfully writing to a spreadsheet I got this error when attempting to call the a function which does something with the range.
Sorry this question is so vague, but its because I am actually using another toolkit to take care of the Excel writing.
Anybody know if there is a lookup table for Excel ActiveX calls anywhere?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
此错误代码的意思是“需要对象”。
听起来您的工具包可能存在内存泄漏，或者过早地处置了对象。
This error code means "Object Required."
It sounds like your toolkit might have a memory leak, or it is disposing of an object prematurely.
工具包中可能没有正确处理范围对象。如果这是 NI 的报告工具包，您可以打开子 vi 并放置探针来排除错误。 （不过，这可能已经改变了。自从它被重写以来，我还没有看过它。）
LV 中公开的 Excel 函数被不同地称为“自动化”或其“对象模型”。您可以在 http://support.microsoft.com/ 中找到有关在何处找到其帮助的信息。 kb/q222101/。该页面上的许多链接都有非常好的文本代码示例，如果您愿意的话，可以将其转换为 LV 代码。
当然，NI 网站上有许多 Excel 示例，位于 http://www.ni.com/分析/excel.htm
It's possible that the range object isn't being handled properly in the toolkit. If this is NI's reporting toolkit, you can possibly open the sub-vi's and place probes to troubleshoot the error. (This may have changed, though. I haven't looked at it since it was re-written.)
The Excel functions exposed in LV are variously called "automation" or its "object model". You can find information on where to locate the help for it at http://support.microsoft.com/kb/q222101/. A number of the links from that page have pretty good text code samples that can be translated into LV code if you care to do so.
Of course, NI's site has a number of Excel examples at http://www.ni.com/analysis/excel.htm