Author Topic: Recent MS Office updates creates problems with VBA  (Read 2852 times)

0 Members and 1 Guest are viewing this topic.

Keith™

  • Villiage Idiot
  • Seagull
  • Posts: 16899
  • Superior Stupidity at its best
Recent MS Office updates creates problems with VBA
« on: January 01, 2014, 01:13:26 PM »
I had several calls regarding VBA projects and addins that suddenly stopped working after updates from Microsoft. As it turns out, a recent update to MS Office causes problems with macros that use the MSCOMCTL.OCX library.

You may receive an error that the VBA project is corrupted or it may simply refuse to run. Office addins may also stop working or generate errors that erroneously indicate that the security level is too low or that macros have been disabled.

To resolve this situation, you must unregister the MSCOMCTL.OCX library and reregister it using regsvr32.exe

To unregister you will use "regsvr32.exe /u mscomctl.ocx"
To register it, similarly the command is "regsvr32.exe mscomctl.ocx"
Proud provider of opinion and arrogance since November 22, 2003 at 09:35:31 am
CadJockey Militia Field Marshal

Find me on https://parler.com @kblackie