There is no official replacement for the much-loved date picker in the 64-bit version of Office 2010, as shown in the following article and forum post by Microsoft:ĭate Picker 2015 Fixes For Active-X Issues Developers who use the Date Picker are advised to stay with the 32-bit version of Office 2010.
Important Note: The Active-X Date Picker can be registered for Office 2010 32-bit, but it will not work on Office 2010-64-bit. If you want to stay with Microsoft offerings and you are running Office 32 bit, then keep reading the article below. These are not official Microsoft solutions, but users of the 64-bit systems said they worked: Microsoft discontinued the legacy 32-bit calendar control, MSCAL.OCX, in Excel 2010 and replaced it with the new 32-bit Date Picker contained in Active-X library member mscomct2.ocx.ĭate Picker Alternatives For 64-Bit Office: Several 'private' solutions have been posted on varoius forms. Learn more about the deployment considerations for 圆4 and x86 at this TechNet location: Important: Microsoft strongly recommends the use of 32-bit (x86) versions of Office 2010, Project 2010, Visio 2010, and SharePoint Designer 2010 applications as the default option for all platforms. Note: The process below will only work for Office 2010 32-bit (not Office 2010 64-bit). Learn some of the secrets to great Excel VBA programming!! Links To Access Code Examples DAO Versus ADODB Links To Excel Code Examples Tracing VBA Statements
