Excel Monthview Control Missing
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 (), 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.
The Date and Time Picker is part of a library of tools with the catchy title of MSCOMCT2.OCX. To start with, you'll need to download this file from the Microsoft support site. Click this link on the page to start downloading the file. Re: Excel 2010 Month View Control missing are you using 64bit Office? Do you have any of the other controls from that library available such as 'Microsoft Date and Time Picker Control 6.0' or 'Microsoft Flat Scrollbar control 6.0'.
The Date and Time Picker is immensely useful when designing VBA user forms but, sadly, it isn't included with every version of Windows. I discovered this recently when moving to a new machine with a 64bit edition of Windows 7 installed. Fortunately, it is relatively simple to install the Date and Time Picker, as long as you don't mind getting your hands dirty with a couple of simple command line instructions. Downloading the Files You'll Need The Date and Time Picker is part of a library of tools with the catchy title of MSCOMCT2.OCX.
To start with, you'll need to download this file from the. Hindi remix song free download.
Hello, I have Windows 8, 64bit and Office 2010 I am trying to get the 'datepicker' (MonthView) ActiveX control toolbox in Excel 2010 as part of a Excel UserForm I have created. I have spent all day trying to find a solution for my problem. I opened up the 'more. ' but the MonthView/datepicker/calendar control is not listed.
I referred to some articles and confirmed that I do indeed have the mscomct2.ocx file in the C: Windows syswow64 folder. I followed the instructions as above, opening up the Administrator Command Prompt and changed the directory to C: Windows syswow64 and typed in RegSvr32. I received a popup screen confirming my registration was successful Excel was closed. So I opened Excel and checked out the ActiveX Tool box and clicked on the 'More Controls', but there was no listing for the Microsoft MonthView control, (nor datepicker/calendar). I then downloaded the latest Windows Common Controls 2 6.0 from the following site Copied the original file (2008) and saved it elsewhere on the comp uter for safekeeping. Extracted the new mscomct2.ocx. Under the C: Windows syswow64 I changed the original file properties to allow me to overwrite it with the new file.
This worked old file replaced. I then registered the new file via the Administrator Command Prompt (as above) and was notified that it was successful. I rebooted pc and went back into Excel to find the MonthView in the ActiveX toolbox, More Controls and it still wasn’t there I would be very grateful if someone could advise how I can get this control and allow me to use it.
If I have left out any information that you need to resolve this issue, please advise. Cheers, TheShyButterfly Hope you have a terrific day, theShyButterfly. Hi, The pictures which you uploaded failed three, would you like to upload again? Which Office 2010 version did you use? 64-bit or 32-bit? As far as I know, ActiveX controls library, could not be used in Office 64-bit version.
If you use Office 2010 32-bit, please try to do the following steps: * Go to Start All Programs Accessories. * Right-click Command Prompt and then click on Run As Administrator. * Change directory to the folder where you extracted the files. * Type the following and then press Enter: regsvr32 Windows SysWOW64 mscomct2.ocx * You should get a message saying this succeeded.
For more detail information, please refer to the following link: Regards, George Zhao TechNet Community Support. Hi George, Thank you for checking this out.:) I am using Office 2010 64 bit. I found the mscomct2.ocx file originally within the C: Windows syswow64 directory (this was an original file.
Which I expect was installed via Microsoft at the time of the Office installation. As I mentioned above, I followed the instructions (same as the ones you suggested), but still no go, even though it stated that the registration was successful!:( Why weren't these features included in the 64 bit? Yes, I read the article. So MS doesn't think that people/developers would be needing this in due course? I installed the 64bit version because I'm running the Win8 64bit version. And I deal with a lot of large spreadsheets and can't afford to sleep whilst they decide to load.