VBA Automation Error while opening MS Excel

When launching MS Excel user get a Visual Basic Pop-up stating “Automation Error"

Solution:
We need to unregister mscomctl.ocx and then register this file with regsvr32

Open Command Prompt with Admin ID & type the command “regsvr32 /u mscomctl.ocx” then press enter

Type the next command “regsvr32 mscomctl.ocx” & then hit enter
This should resolve the issue

***Share your comments about this post***

No comments:

Post a Comment