A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
- The first thing I need to explain to you is that you can register the calendar control in a 64-bit system, but it only works with 32-bit office. Even if you add the reference to mscomct2.ocx/mscal. When ocx is in Excel 64-bit, it still returns the "Cannot load object because it is not available on this machine" error.
- Below are the steps I give you to install Microsoft Date and Time Picker Control 6.0 (SP6):
Click the Windows Start button, type mscomct2.ocx or mscal.ocx in the search box, and hit Enter.
- If the file of mscomct2.ocx can be found
• Right-click the Start button, Windows Terminal (Admin) -> then enter the following command:
For Windows 32 bit:
C:\Windows\System32\regsvr32.exe mscomct2.ocx
For Windows 64 bit:
C:\Windows\SysWoW64\regsvr32.exe mscomct2.ocx
• Then click Enter, the file mscomct2.ocx will be successfully registered on your computer.
• Once mscomct2.ocx is registered, restart Excel, go to the "Developer" tab, click "Insert" -> "More Controls", the Microsoft Date and Time Picker control will appear.
Hope it helps.