如何解决VBA出现Automation Error 错误
来源:互联网 发布:恒璞网络信息 编辑:程序博客网 时间:2024/05/02 00:44
How to solve the message "Microsoft Visual Basic: "Automation error: Unspecified error (440)" with MS Office Excel?
It can happen that an export of data to Microsoft Office Excel shows the notification "Microsoft Visual Basic: Automationerror: Unspecified error (440)". Also opening Microsoft Excel itself will displays this notificiation. After a recent Microsoft update the notification will occuur with Microsoft Office.
The notification can be solved by registering the file MSCOMCTL.OCX again.
- Check if the machine is 32 of 64 bits.
- Go to [Start-run] on the workstation/server.
- If it's a 32 bits machine type the following: regsvr32 C:\windows\System32\MSCOMCTL.OCX
- If it's a 64 bits machine type the following: regsvr32 C:\windows\SysWOW64\MSCOMCTL.OCX
After doing this a notification will come that the file is correctly registered. If this is not the case and you get for instance the following notification
"'MSCOMCTL.OCX' is loaded but the call to DllRegisterServer failed with error code 0x80004005.", this could be due to security issues on the workstation / server.
If this is the case make sure the Windows "Dos Prompt / Command Prompt" is opened with "run as administrator". To do this go to [Start-all programs-accessoires] and click with right mouse on the "Command Prompt" and choose to run as administrator.
In the Command Prompt screen you can type the line (regsvr32 C:\windows\System32\MSCOMCTL.OCX or regsvr32 C:\windows\SysWOW64\MSCOMCTL.OCX) and press enter.
After the file is correctly registered opening Microsoft Excel will not show the notification anymore and exports out of Exact Globe will also work correctly.
For more information about the Microsoft updates which cause this notification use the following links:
- http://support.microsoft.com/kb/2687441
- http://support.microsoft.com/kb/2596615
- 如何解决VBA出现Automation Error 错误
- VBA中使用ADO,参数化查询出现 Automation error
- 如何解决关于函数timeGetTime出现的error LNK2019错误
- weblog项目部署:出现Session Error 错误 如何解决
- VBA 出现400错误
- 出现 “严重: Error listenerStart”错误的解决
- 如何解决apktool d -d 出现错误Error occured while disassembling class
- BI Publisher Error:自动化(Automation)错误
- 运行ASP时出现Automation错误解决方法!
- Rose2003运行出现 -2147417848 (80010108)':Automation 错误
- sp_configure启用Ole Automation Procedures 出现错误
- 解决mysql安装是出现Error Nr2003、Error Nr1045错误
- mysql错误:Error NO. 1130?如何解决?
- Eclipse经常出现OutOfMemory错误,如何解决
- 如何解决myeclipse导入工程出现错误
- Automation服务器不能创建对象,如何解决?
- 解决IE出现Runtime Error Iexplore.exe的错误
- 安装MATLAB7.0 出现runtime Error错误解决
- AJAX
- 完成端口(CompletionPort)详解
- SQL Server分页最佳解决方案
- Ubuntu12.04下MyEclipse_10.5安装及破解
- Ubuntu下安装MyEclipse10和MySQL全程图解
- 如何解决VBA出现Automation Error 错误
- POJ2299--归并排序--Ultra-QuickSort
- 各种不一样的求职简历
- 作为Ubuntu新手,记录下自己的傻逼历程
- MOSS工作流 InfoPath+WorkFlow+Moss 开发要点
- InfoPath + Workflow + MOSS
- Java中的值传递和引用传递
- 栈之括号匹配问题
- String,StringBuffer与StringBuilder的区别