运行时错误-2147417848（80010108） [英] Run Time Error -2147417848 (80010108)

问题描述

请帮助：

运行时错误-2147417848（80010108）

我最近在运行时遇到上述运行时错误一个值得信赖/可靠的Excel宏文件（多年来一直在使用和开发）使用Excel 2010（在Excel 2013和不同的PC上也是如此，但在使用Excel 2007的老式笔记本电脑
上工作正常，奇怪）。最近没有什么变化，所以我想知道我的文件是否已损坏或是否有简单的修复？

完整消息：自动化错误，调用的对象已与其客户端断开连接。

当我选择调试时，代码已在行读取停止：Selection.Delete Shift：= xlUp

我已经清理了所有代码并重建了文件（但没有然而是大量数据的工作表。

正在使用的参考资料：

- Visual Basic for Applications

- Microsoft Excel 15.0对象库

- Microsoft Office 15.0对象库

- Microsoft Forms 2.0对象库

- Microsoft Scripting Runtime

- Microsoft PowerPoint 15.0对象库

我运行Excel 2010，因为它比2013年更有效地工作。不使用更高版本。

任何帮助都非常感谢。

Andy

解决方案

Hello Andy，

您在何时何地运行基于Excel的解决方案？ 

无论如何，尝试运行c ompatability问题排查工具。请参阅  Excel VBA"自动化错误：对象
调用已与其客户端" 断开连接以获取更多信息。 

Help Please:

Run Time Error -2147417848 (80010108)

I have been recently experiencing the above runtime error when running a trusted/reliable excel macro file (been using and developing it for years) using Excel 2010 (the same thing happens with Excel 2013 and on different PC's but works fine on older laptop using Excel 2007, strangely). Nothing has changed recently so I am wondering if my file has corrupted or is there a easy fix?

Full message: Automation error, The object invoked has disconnected from its clients.

When I select debug, the code has stopped on line reading: Selection.Delete Shift:=xlUp

I have cleaned all the code and rebuilt file (but not yet the sheets which are numerous and lots of data.

References being used:

- Visual Basic for Applications

- Microsoft Excel 15.0 Object Library

- Microsoft Office 15.0 Object Library

- Microsoft Forms 2.0 Object Library

- Microsoft Scripting Runtime

- Microsoft PowerPoint 15.0 Object Library

I run Excel 2010 as it works more efficiently for my purposes than 2013. Not used later versions.

Any help really appreciated.

Andy

解决方案

Hello Andy,

Where and when do you run your Excel-based solution? 

Anyway, try to run a compatability troubleshooter. See Excel VBA "Automation Error: Object Invoked has disconnected from its clients" for more information. 

这篇关于运行时错误-2147417848（80010108）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！