This package updates two Microsoft Visual Basic 6.0 Common Controls: mscomctl.ocx and comctl32.ocx to address the issues described in the KB articles noted in the Related Resources section on this page. Dec 30, 2016 >> I installed 'Microsoft Visual Basic 6.0 Common Controls' and registered 'mscomct2.ocx' Where did you put the 'mscomct2.ocx' file? As far as I know, how you register the control depends on the version of Windows (32-bit or 64-bit).
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.
Community♦
rryanprryanp
2 Answers
You're correct that this is really painful to hand out to others, but if you have to, this is how you do it.
Just extract the .ocx file from the .cab file (it is similar to a zip)
Copy to the system folder (c:windowssysWOW64 for 64 bit systems and c:windowssystem32 for 32 bit)
Use regsvr32 through the command prompt to register the file (e.g. 'regsvr32 c:windowssysWOW64mscomct2.ocx')
References
wilsjdwilsjd
Click the Start button, then in the 'Start Search' box, type CMD but DO NOT press Enter yet.
Run CMD as in Admin mode and click 'Continue'.
In the open window, type the following command and press Enter:regsvr32 c:windowssysWOW64mscomct2.ocx
Jimit RupaniJimit Rupani
Not the answer you're looking for? Browse other questions tagged excelexcel-vbavba or ask your own question.