I got a message like “MISSING: Microsoft Windows Common Controls 2.6.0? and I’m using 64bit Windows 7. Here are the steps I had to take to fix:
- Download the cab files from this knowledgebase article.
- Right click on the CAB file and choose 7-zip – Extract to mscomct2
- Open that folder and copy the two files (.ocx and .inf) to C:Windowssyswow64. Hit the “Continue” button with the admin symbol on it
- Start button and type ‘cmd’. Right click on the cmd entry that’s found and choose Run as Administrator
- In the command windows, change the directory to c:windowssyswow64
- Type ‘regsvr32 mscomct2.ocx’ and press enter
Hi Dick,
Silly question maybe, but is this the 32 bit version of the ocx you’re instaling?
And what Office version are you using here? Does the control work with 64 bit 2010?
7-zip? That’s not part of 64 bit versions of Windows 7, is it?
So by implication, you consider 7-zip a necessary utility?
JKP: Yes, 32 bit version of the ocx. Haven’t tried 64 bit Office and was told not to unless I had a compelling reason. I don’t even have a non-compelling reason, so I haven’t even sniffed it.
Re 7-zip: Not necessary. I assume any compression utility that works on 64 bit Windows will work equally well. JustZipIt is my favorite, but it doesn’t work in 64 bit last time I tried. 7-zip is next on my list of favorites.
I chose the words “…steps I had to take…” carefully for a good reason: I don’t completely understand the steps; I just know that I followed them and it worked. :) Not understanding all the implications means that it surely won’t work for everyone or that I glossed over something that was obvious to me but may not be to someone else. I had to go to about five websites to piece it all together, so I thought having it all in one place would be good.
I was just pleasantly surprised to see the DOS prompt. The latest wares and a little nostalgia.
Long-time reader, first-time poster. Love the site.
I developed a tool in Excel 2003 that was in use for a whole year without issues. Then most of our users were upgraded to 2007. It took a bit of work to get the tool working in both environments, but this was donw and all seemed well. Then the other week a user complained that they were unable to use the tool. I worked out that they had had their PC re-imaged so had never had Office 2003 installed; therefore they never had mscomctl2.ocx on their system (the tool uses the datetimepicker control form this library). The simple fix would be to install the mscomctl2.ocx on the user’s PC. However, I can’t work out a way to do this as this particular user doesn’t have admin rights – also this problem is likely to occur in the future as other users trash their machines and require them to be re-built. Ideally I’d like to find an alternative to the DTPicker. I thought I’d found one in the shape of the calendar control, but surprise surprise, this too was missing from that user’s PC.
Anyone have any ideas for alternatives to these controls, or am I missing something obvious?
Cheers!
wlad: I tried to make an alternative to the DTPicker just a few weeks ago. It wasn’t even good enough to post as a failure. I would really love an alternative using built-in controls. Maybe I’ll take another shot at it.
wlad: I agree, I recently edited a *.xlsm spreadsheet developed in Office 2007 & today I downloaded a trial of Office 2010, only to find that the xlsm doesn’t work – as it has 2 CalendarControls (for parameters to a Stored Procedure) which have been removed from Excel 2010 – for what good reason!!!
Why do they have to keep removing stuff so spreadsheets are not compatible across versions… anyhow, I’d like something similar for Excel 2010 but I dont want each user to have to install a file though. Might just have to stick with a date cell & get the user to manually enter their date.
Thanks for the replies. I had been missing something obvious – simply use three pre-populated combo boxes; one each for day month and year. My app is for a European userbase so I put them in that order on the form. To prevent the user selecting an invalid date (e.g. 30th Feb) I put some code in the _change event of the month combo to validate the day. I’ll post the code when I’m back in front of my work PC.
wlad, yeah I was thinking of something like that too but wasnt sure how to go about it… but I liked the simplicity of the calendar control. Month Day Year combo boxes & filter day based on month (eg: if select Feb only show 1 to 29)… but if feb29 selected would have to validate year or maybe just populate it with leap years. Still learning stuff lol. :)
Thanks for the step by step instructions, it worked and helped me a lot
I created my own version of Calendar here (in portuguese): http://www.ambienteoffice.com.br/officevba/calendario_pop-up/
You’ll be able to understand the example file: http://www.ambienteoffice.com.br/officevba/calendario_pop-up/exemplo.rar
Hi
We have developed a class so it works on all versions. We replicated the calendar control properties, methods, events to facilitate the migration of legacy applications … Please read:
https://sites.google.com/site/e90e50/calendar-control-class
best regards
r
Related posts:
* Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010)?
http://www.mrexcel.com/forum/showthread.php?t=477358
* Problem with Date/Time Picker in Excel 2000
http://www.mrexcel.com/forum/showthread.php?t=70813&page=2
* Multi-compatible Excel xlsm – how to solve object/activex/reference issues:
http://www.xtremevbtalk.com/showthread.php?t=316914
* Excel – Date & Time Picker / Calendar Controls – multi compatible ???
http://social.msdn.microsoft.com/Forums/en/exceldev/thread/c7ccebe5-5d7f-4fb2-ae16-1438e0e736a4
* Calendar Control DLL on Windows 7 64 Bit
http://www.dailydoseofexcel.com/archives/2010/05/28/calendar-control-dll-on-windows-7-64-bit/
Thanks, you save me.