none
Calendar Control for All Office Application RRS feed

  • Question

  • Hi 

    I have Calendar Control in Excel 2007 VBA forms. But now we are upgrading to Excel 2016 64 bit edition. I found Calendar control is missing in Excel 2016 and it is giving error.

    How do I get the calendar control which can support excel 2007 and Excel 2016 at same time

    Regards

    Sajith


    • Edited by Sajith S Wednesday, September 21, 2016 8:31 PM
    Wednesday, September 21, 2016 8:29 PM

Answers

  • Hi Sajith S,

    Existing 32-bit ActiveX controls, both third-party and Microsoft-supplied, are not compatible with the 64-bit version of Office 2010. 

    For more information, click here to refer about Compatibility Between the 32-bit and 64-bit Versions of Office 2010

    >>>which can give similar calendar control like in Office 2007.

    You could customize Calendar Control, refer to Calendar Control for All Office versions - including Office 2010 64 bit

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Friday, September 30, 2016 2:16 AM
    • Marked as answer by David_JunFeng Friday, September 30, 2016 2:16 AM
    Friday, September 23, 2016 6:50 AM

All replies

  • >>>But now we are upgrading to Excel 2016 64 bit edition. I found Calendar control is missing in Excel 2016 and it is giving error.

    According to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of Office. In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX.
    If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems.

    For more information, click here to refer about Installing the Date Picker

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Thanks for your understanding.
    Thursday, September 22, 2016 6:42 AM
  • If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems.

    Just to clarify, ActiveX controls like the Date Picker and others can work with in 64-bit systems but only with 32-bit Office.

    The dll or ocx file must be located in the sysWOW64 folder and correctly registered

    Thursday, September 22, 2016 8:10 AM
    Moderator
  • Thanks.

    So to conclude there is no control in Office 2016 64 bit system, which can give similar calendar control like in Office 2007.

    Please confirm this. I need to pass this information to my seniors. We will think of plain text control and Validation for dates.

    Thursday, September 22, 2016 11:02 AM
  • Hi Sajith S,

    Existing 32-bit ActiveX controls, both third-party and Microsoft-supplied, are not compatible with the 64-bit version of Office 2010. 

    For more information, click here to refer about Compatibility Between the 32-bit and 64-bit Versions of Office 2010

    >>>which can give similar calendar control like in Office 2007.

    You could customize Calendar Control, refer to Calendar Control for All Office versions - including Office 2010 64 bit

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Friday, September 30, 2016 2:16 AM
    • Marked as answer by David_JunFeng Friday, September 30, 2016 2:16 AM
    Friday, September 23, 2016 6:50 AM
  • Hi

    Have a look at the link below, maybe it can help, we never got feedback if he found a solution.

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/date-picker-in-office-365/c0cc6a18-340c-40be-add5-50af25726ab9


    Cimjet

    Friday, September 23, 2016 7:58 PM