Jan
6
Daniel Curran on January 6th, 2009
(27 votes, average: 4.04 out of 6)
Loading ...
(27 votes, average: 4.04 out of 6) Loading ...In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
Looking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.
To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip”
Once the file is unzipped simply run the MSCOMCT2.BAT batch file!
February 23rd, 2009 at 9:02 am
I have developed a worksheet for my department and it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm. When I distributed the worksheet, a few employees have had the debugger come up when the UserForm appears because their version of excel does not have the Microsoft Date and Time Picker as an option under "Additional Controls…" on the toolbox pulldown. I tried installing the Picker using your instructions above but all that happened was it ran a command box for a split second and then nothing happened. Any suggestions? Some Microsoft Excel 2003 users have the control, others do not. Can the problem be resolved through a service pack download or some sort of Microsoft update? Or perhaps you may know what I am doing wrong when I tried running the above download. Any ideas would be appreciated!
Thanks, Ian
March 11th, 2009 at 1:41 pm
Ian, did you run it as the local administrator?
March 17th, 2009 at 11:47 am
Exactly what I was looking for. Thanks!
April 9th, 2009 at 1:40 am
Unzipped the file and ran the batch file but said "Access is Denied". Tried running as Administrator too and that didn't do anything different
May 7th, 2009 at 10:49 am
THANKS.
August 21st, 2009 at 6:28 am
Hi
Can I put date and hour together? is there this resource in microsoft date and time picker 6.0
January 17th, 2010 at 8:33 pm
I tried to follow the above steps to insert a drop down calendar to pick a date, however after I make the box for the date to appear, it says cannot insert object. Pls. help.
January 22nd, 2010 at 4:18 am
Hi i ran the bat file but nothing happens. The dos window opens up and closes within a sec… Ur reply is very important.. please anyone help
February 8th, 2010 at 11:56 pm
Hi, I am also facing the same issue of "cannot insert object" even after appying the same method as given above.Help appreciated
Piyusha
February 11th, 2010 at 7:03 am
Thank this actually helps after installing SP4
February 18th, 2010 at 7:12 pm
This doesn’t work. I get the same problem as Ian and Mary. Command window pops up for a split second, then closes.
February 18th, 2010 at 7:13 pm
This doesn't work. I get the same thing as Mary and Ian. Command window opens up for a split second then closes.
February 26th, 2010 at 11:30 am
Worked like a charm. Only wish there was an easier way to get a colum of these dates without copying and pasting the control over and over again and changing the linked cell for each one.
March 29th, 2010 at 7:09 pm
I actually unzip "Microsoft Date & Time Picker Control 6.0 (SP4)" but still cant run" MSCOMCT2.BAT "
July 30th, 2010 at 7:13 am
Copy both the .bat file and the .OCX file to your desktop. Copy the MSCOMCT2.OCX to your system32 folder, then run the batch file "as administrator". Reopen excel and check controls. And there it was. Works great. Wish I could blank it out but looks like there has to be a date in there after you select an initial date.
September 1st, 2010 at 11:08 am
McCoy
Thank you so much for your help
It really works great
September 15th, 2010 at 12:13 am
Thanks for that however when i put it on excel 2010 the addin has for name "Microsoft Date and Time Picker Control 6.0 (SP6) and does not seems to be working correctly.
By the way for those having the problem "cannot insert object" , this is because you coding actual is preventing you from adding another object. Try removing the code and give it a try.
Regards,
Guest
October 23rd, 2010 at 7:17 am
Hi McKoy, I've done as adviced above; did a MSCOMCT2.BAT download but I can't see it run. The windows just flickers and disappears pretty fast. I've equally tried the second option of copying both .bat file and the .OCX file in system32 folder, and ran it, but this didn't have the DT Control installed on to the additional ActiveX Controls. How else can I install this?
I'm the administrator in my machine. By the way, this a windows 7 OS.
November 29th, 2010 at 10:27 am
Downloaded cab file, extracted files, manually copied ocx file to system32 folder, manually executed regservr32. Opened Excel. Under Developer tab, more contorls (AX), object not in list. Selected to manually register MSCOMCT2.OCX, and got error, "Cannot register this control.". This is Windows 7 (64-bit) and Excel 2003.
December 14th, 2010 at 3:18 am
Everyone's referring to the BAT file, but I only see an OCX and an INF file. Should I rename the INF to .BAT and run it or …..
December 17th, 2010 at 9:35 am
Since my initial comment above well over a year ago I have had success registering the MSCOMCT2.OCX and installing the DT Picker Control on all our systems. However, as systems in our department are switching over to Windows 7 I am having a similar problem to "Guest" where the control will not register. I am guessing it has to do with the enhanced safety features on Windows 7 and restrictions on being able to download content, even if logged in as the administrator. Anyone have a solution for this?
December 22nd, 2010 at 1:52 pm
In Windows 7 64-bit ocx is in c:windowssysWOW64 folder. The registry settings will depend on flavor of MSO with regards to 32- or 64-bit. Do you know if it is MSO that adds this control to the system?
December 22nd, 2010 at 1:54 pm
just have notised missing "" backslash it path c:""windows""sysWOW64
January 31st, 2011 at 3:03 am
Having the same problem trying to register the DT picker control (MSCOMCT2.OCX ) – getting the 'cannot register this control' error. Running the batch file gets me an 'Access denied' error in the command prompt window. I'm using Win7 on a workstation at my office, the only thing I can assume is that it's due to my admin permissions, however, the IT guy can't figure it out either
February 2nd, 2011 at 9:02 am
Ian, glad to know you were able to solve this problem. Can you share your solution as I am currently having this problem.
February 3rd, 2011 at 10:11 pm
Unbelievable…how hard does this have to be!!!!!! I mean I just want to insert a calendar option.
February 28th, 2011 at 1:23 am
c:windowssysWOW64 folder — ???? Where's this folder in Win 7
June 6th, 2011 at 7:00 am
I copied the MSCOMCT2.OCX file to the System32 folder (after getting an Access Denied message from the .bat file). However, I still get the "Could not load some objects because they are not available on this machine" error message when trying to install an Outlook UserForm that had a DateTimePicker control on it (this userform was created on another computer, which had — long ago — had the Developer Edition of Office 2000 on it, the original source of this control).
So it appears that just copying the .ocx file isn't enough. What else is needed?
June 11th, 2011 at 4:08 am
Do you know what the control is named in that folder?
June 11th, 2011 at 4:40 am
I'm running Windows 7 (64-bit) and Excel 2010 (32-bit).
I followed the instructions on this page: http://www.rondebruin.nl/calendar.htm
Apparently if you are using Excel 2010 (64-bit), you can't use this solution.
(1) I downloaded MSCAL.OCX (http://www.gmayor.com/Zips/MSCAL.zip)
(2) Unzipped and followed the directions in "Installation instructions for mscal.pdf"
I don't know if this is the tool you're all talking about, but it seems to solve the issue I've been having.
June 11th, 2011 at 4:55 am
You're probably using a different version of Windows and/or Excel than the people on this forum.
What worked for me, step-by-step for people as lost as I was …
(1) I'm running Windows 7 (64-bit) and Excel 2010 (32-bit) … rumor has it Excel 2010 (64-bit) simply doesn't have a solution.
(2) Download the .CAB file, unzip it and place the file "MSCOMCT2.OCX" in the folder "C:WindowssysWOW64" if you're running Windows 7 (64-bit) or place it in the folder "C:WindowsSystem32" if you're running Windows (32-bit). You'll get a prompt that you need to be an Administrator, accept all of that.
(3) Click the Start-Menu, where it says "Search Programs and Files" in the little search form at the bottom of the start menu, type "cmd" … right click on the icon and select "Run as Administrator"
(4) Now you'll have a command line opened, type "cd WindowssysWOW64" if you're using Windows 7 (64-bit) or type "cd Windowssystem32" if you're using a 32-bit version of windows. Press Enter.
(5) type "regsvr32 MSCOMCT2.OCX", press Enter.
(6) You should be all set … just go back to Excel, click your Developer tab, click "Insert" … "More Controls" (icon in the bottom right of the box)
(7) Select "Microsoft Date & Time Picker" out of the menu.
Hopefully this helps someone
July 24th, 2011 at 10:29 am
THANKS!!!, SO MUCH, I NEED FOR AN APPLICATION
September 7th, 2011 at 11:56 pm
Nice post. I learn one thing more difficult on different blogs everyday.
September 27th, 2011 at 8:31 am
Works a treat – thanks!
September 29th, 2011 at 6:04 am
Anyone know how to get rid of the drop down calendar now? It worked for a month or so and now when I open my files including the ones it worked fine in, the box contains a large red X and I can't do anything with it. Even in Design mode, I cannot select the box and delete it. HELP, please!
September 29th, 2011 at 6:23 am
Sratch that … it was an ID10T error.
Sharon
December 29th, 2011 at 8:08 pm
hey Andrew,
i follow your suggestion, it really works great
thank u
February 6th, 2012 at 10:25 am
Thanks, the calander works great – only problem is when I close excel and re-open the calander box keeps going back to it's origanal size after I have made it smaller, is there away to keep it the same size?
February 10th, 2012 at 3:12 pm
HI Andrew. When I type "cd WindowssysWOW64" I get "the system cannot find the path specified". The only difference between your set up and mine is that I am using Excel 2007. in hte command prompt administrator I am on path c:Windowssystem32. I am hoping you have a suggestion for what I am doing wrong. thank.
March 16th, 2012 at 6:42 am
Sorry – you need backslashes before windows, system32 and mscom…. (the s/w pinched them above)
April 17th, 2012 at 11:19 pm
it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm.
May 8th, 2012 at 8:47 am
HOW DO YOU REMOVE THE CODE
May 10th, 2012 at 3:09 pm
I'm not sure if anyone on here got a clear resolve. You can copy the .OCX file to the computer and register it through EXCEL. Just Go to Developer > Insert > More Options > Register Control (Find where you copied the file to) This will register the file to Excel. I hope this helps.