如何解决VBA出现Automation Error 错误

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:

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值