• Curran@CurranOmniMedia.com

How to Install Microsoft Date & Time Picker Control 6.0 (SP4)

70 Comments

  • Ian Fife

    February 23, 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

  • wahtx

    March 11, 2009 at 1:41 pm

    Ian, did you run it as the local administrator?

    Jake

    March 17, 2009 at 11:47 am

    Exactly what I was looking for. Thanks!

    Keane

    April 9, 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

    HENRY

    May 7, 2009 at 10:49 am

    THANKS.

    Eliana

    August 21, 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

    Val

    January 17, 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.

    Mary

    January 22, 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

      Andrew

      June 11, 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

        Indra

        December 29, 2011 at 8:08 pm

        hey Andrew,

        i follow your suggestion, it really works great

        thank u

        guest

        February 10, 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.

        Magnus

        October 3, 2012 at 11:57 pm

        Only solution that worked for me and it works perfectly
        Thanks

        James

        February 22, 2013 at 7:32 pm

        I was getting confounded because I am using 64 bit windows. This worked perfectly. Thank you very much!

        zeeshan

        December 19, 2014 at 10:05 pm

        Thanks alot andrew, it solved my problem.

        Jonesy

        September 30, 2015 at 6:22 am

        Thanks for these steps. Worked great.

        Pearlin

        January 21, 2016 at 10:10 pm

        Hi, Andrew,
        I have tried your step ,but i can not work stil.The dllregistserver run sucessfully.
        I’m also running Windows 7 (64-bit) and Excel 2010 (32-bit).

        bhanu chander

        September 20, 2017 at 1:57 am

        IF i type this “regsvr32 MSCOMCT2.OCX”, and press Enter i am geting error 0x8002801c

    piyusha

    February 8, 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

    Lanre

    February 11, 2010 at 7:03 am

    Thank this actually helps after installing SP4

    Jeremy

    February 18, 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.

    Jeremy

    February 18, 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.

    Neal

    February 26, 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.

    jenny

    March 29, 2010 at 7:09 pm

    I actually unzip "Microsoft Date & Time Picker Control 6.0 (SP4)" but still cant run" MSCOMCT2.BAT "

    McCoy

    July 30, 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.

      Benjamin

      October 23, 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.

      ahlDRO

      May 4, 2016 at 6:42 am

      You have the best, the most explicit advice over this issue, and it works like wonders for me. I am running an MS Excel 2016 on my Acer Iconia TabW and this bugged me for a while until I followed your idea. I commend you for giving such clear instructions which I observed is increasingly becoming a rarity today in every advice forum today.

      Thank you so much for your concise instructions. Keep it up and more power! Your such a help!

    Clau

    September 1, 2010 at 11:08 am

    McCoy

    Thank you so much for your help

    It really works great

    Guest

    September 15, 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

      Rose

      May 8, 2012 at 8:47 am

      HOW DO YOU REMOVE THE CODE

    Guest

    November 29, 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.

      Ian

      December 17, 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?

        Tagene

        February 2, 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.

    Michael

    December 14, 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 …..

    Irek

    December 22, 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?

      Irek

      December 22, 2010 at 1:54 pm

      just have notised missing "" backslash it path c:""windows""sysWOW64

        Andrew

        June 11, 2011 at 4:08 am

        Do you know what the control is named in that folder?

    Adam

    January 31, 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 πŸ™

    Guest

    February 3, 2011 at 10:11 pm

    Unbelievable…how hard does this have to be!!!!!! I mean I just want to insert a calendar option.

    guest

    February 28, 2011 at 1:23 am

    c:windowssysWOW64 folder — ???? Where's this folder in Win 7

    Helen Feddema

    June 6, 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?

    Andrew

    June 11, 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.

    CIL

    July 24, 2011 at 10:29 am

    THANKS!!!, SO MUCH, I NEED FOR AN APPLICATION

    Ugg Winter Boots

    September 7, 2011 at 11:56 pm

    Nice post. I learn one thing more difficult on different blogs everyday.

    Jimmybangs

    September 27, 2011 at 8:31 am

    Works a treat – thanks!

    Sharon

    September 29, 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!

      Sharon

      September 29, 2011 at 6:23 am

      Sratch that … it was an ID10T error. πŸ™‚ Sharon

    Craig

    February 6, 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?

    Carolann Herrick

    April 17, 2012 at 11:19 pm

    it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm.

    John Remmes

    May 10, 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.

    Brian M

    August 2, 2012 at 2:36 pm

    I tried this but the batch file isn't working.

    I download the CAB to my desktop and then unzip the files out of the CAB to my desktop. I then run the batch file as administrator and MS DOS tells me, "The system cannot find the file specified."

    Hammad

    September 3, 2012 at 4:47 am

    Thanks thats what i was looking 4….

    baby blankets

    February 7, 2013 at 9:59 am

    It’s remarkable in favor of me to have a web site, which is valuable for my know-how. thanks admin

    guest

    April 17, 2013 at 10:51 am

    genius it worked exactly as described

    sami

    December 17, 2013 at 12:44 am

    Thanks Every one. great job. its works only on doing these below steps.

    1. download the MSCOMCT2.cab to desktop (reffer the first link “download it here”)
    2. install 7zip. extract the MSCOMCT2.cab file on the desktop.
    3. you get two files “mscomct2.bat” and MSCOMCT2.OCX.
    4. Copy MSCOMCT2.OCX to c:\windows\system32 (if the file is already there rename the old file to MSCOMCTold.OCX) and then try again.
    5. Run the mscomct2.bat (Please use run ad administrator even if you have admin rights)
    Now see the magic… works fine…. i was trying this solution for a month and finally i got it from this site…. thanks every one…. πŸ™‚

    sami

    December 17, 2013 at 12:52 am

    I have added backslashes not sure why its missing (just for testing “c:\windows\system32”)

    sami

    December 17, 2013 at 12:55 am

    haaa… its really missing… some bug on backslashes…. πŸ™ ..

    all, please use backslash after c: and windows…. Thank’s…

      Daniel Curran

      December 19, 2013 at 11:17 am

      c:\\windowssystem32

    Paul

    February 4, 2014 at 12:43 pm

    I combined John Remmes’ information with this and for me running Office 2007 on a Windows 64bit machine, this was my solution to add the Picker Control:

    Download and unzip the .bat and .ocx files.
    Place them into the C:\Windows\System32 folder
    Click on the Developer button.
    Click on Insert.
    Click on the More Controls icon.
    Click on Register Custom.
    This will default to the System32 folder.
    Double click on the MSCOMCT2.OCX file.
    The Microsoft Date and Time Picker Control will now appear in the list.

    active x calendar control

    February 18, 2014 at 6:48 am

    […] you have to install it How to Install Microsoft Date & Time Picker Control 6.0 (SP4) | Daniel B. Curran Jr. but a better way which i implemented is to use a Calendar Class […]

    Dinesh M

    June 2, 2014 at 8:27 pm

    Great! Worked like charm.

    Anupam Sarkar

    June 19, 2015 at 9:22 am

    Thanks a lot man.

    Anupam Sarkar

    July 13, 2015 at 4:53 am

    Thanks a lot for this great work.

    Rupesh

    September 9, 2015 at 7:33 pm

    I tried to follow instruction and was able to save mscomct2.ocx in my syswow64 folder and ran regsvr32 mscomct2.ocx from command prompt as administrator it shows successful but I cannot see microsoft date and time picker in additional control. what am I missing? am using windows 8 with 64bits and msoffice 2013. Please let me know.

    nour

    August 10, 2016 at 2:09 am

    Dears
    I tried everything with ate and Time Picker Control but in vain. I really need your help. it is neither registered manually nor automatically. I am lost and I need your help in having the calendar in my excel sheet.

    Thank You

    Abhishek

    September 18, 2016 at 12:46 pm

    Hi, need help,

    i have downloaded this file and still cannot installed or use the MS time picker option.
    i am using the Ms office 2010 and windows 10.

    Thank you for your kind help.

      Abhishek

      September 18, 2016 at 12:47 pm

      i am using 64bits

    GIORGIO

    February 15, 2017 at 6:21 am

    Following your indications
    with my Office 2007 on Windows Viusta (32 bit)
    I obtain what you promised:

    THANK YOU, Andrew !

    MSP Computer Maintenance

    June 25, 2017 at 7:15 am

    Daniel,

    I had already installed the Microsoft Date and Time picker and every time I would close out of the excel document and re-open it the picker would disappear and just a blank spot was there. I would then have to go into design mode, delete it, recreate it and then link the cell again. I had to explain this procedure and set it up for the vendors as well. It was driving me nuts. I started looked into this and discovered your installation procedure. I ran the files and fantastic, I no longer have a blank cell but I have an oversized calendar showing up. Now, the calendar still doesn’t work but I discovered that if I zoom out and back in by holding the CTRL key down and scrolling up and down on the middle mouse button that the calendar works…

    So THANK YOU THANK YOU THANK YOU!!

    Wayne Leiser, I.T. Director
    B2B I.T. Solutions
    (941) 923-6280
    http://www.b2b-its.com
    M – F: 9am – 5pm EST

    Microsoft Date And Time Picker Control Error – teldent.com

    September 1, 2017 at 10:14 am

    […] How to Install Microsoft Date & Time Picker Control 6.0. – 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. […]

Leave a Reply

%d bloggers like this: