1. It is better to install MS office as 32 bit software even in 64 bit systems if legacy VBA code is being used in some excel files.
2. The common controls (mscomct2.ocx) will not work if office installed as 64 bit application.
3. The common control components like Microsoft Date time picker are obtained if the mscomct2.ocx active x file is added to the system.
4. Do not confuse between Mscomctl.ocx and mscomct2.ocx. The former is used for VB6 and later is used for VBA. download the correct ocx file and register to get the date time picker control in Excel VBA.
5. see this link (or google, if this does not open) for procedure to register active x controls.
https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker
6. irrespective, if your application is installed as 32 bit (meaning it is stored c:\program files (x86) ) in the 64 bit OS system , the OCX file has to be copied to C:\windows\syswow64 and then procedure as mentioned in step 5 to be applied. The 64 bit applications are stored in normal program files folder (C:\program files)
7. By doing step 5 & 6, the date time picker control started appearing in VBA of excel.
2. The common controls (mscomct2.ocx) will not work if office installed as 64 bit application.
3. The common control components like Microsoft Date time picker are obtained if the mscomct2.ocx active x file is added to the system.
4. Do not confuse between Mscomctl.ocx and mscomct2.ocx. The former is used for VB6 and later is used for VBA. download the correct ocx file and register to get the date time picker control in Excel VBA.
5. see this link (or google, if this does not open) for procedure to register active x controls.
https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker
6. irrespective, if your application is installed as 32 bit (meaning it is stored c:\program files (x86) ) in the 64 bit OS system , the OCX file has to be copied to C:\windows\syswow64 and then procedure as mentioned in step 5 to be applied. The 64 bit applications are stored in normal program files folder (C:\program files)
7. By doing step 5 & 6, the date time picker control started appearing in VBA of excel.
No comments:
Post a Comment