How to install mscomct2.ocx file from .cab file (Excel User Form and VBA)

Question

I have an Excel spreadsheet with a user form that uses the calendar control. It works fine on my machine, but others can't use it because they are missing the mscomct2.ocx file. I found where to download it (http://support.microsoft.com/kb/297381), but it comes down as a cab file, and I'm not sure how to tell others to use that file. My internet searches point to a variety of solutions from copying it to the system32 file to registering it using regsrv32. I was hoping somebody here could give me layman's instructions, as I hate to ask these other users to try five different things.

Answer 1

You're correct that this is really painful to hand out to others, but if you have to, this is how you do it.

1. Just extract the .ocx file from the .cab file (it is similar to a zip)
2. Copy to the system folder (c:\windows\sysWOW64 for 64 bit systems and c:\windows\system32 for 32 bit)
3. Use regsvr32 through the command prompt to register the file (e.g. "regsvr32 c:\windows\sysWOW64\mscomct2.ocx")

References

• http://social.msdn.microsoft.com/Forums/en-US/sbappdev/thread/91cf3127-70fe-4726-8a27-31b8964430c5/
• http://en.wikipedia.org/wiki/Cabinet_(file_format)