Hello,
I have a dual OS, so I can chose from boot manager if I want to run Windows XP or Windows 7. Each of them is installed in a different HD and I have no problems at all running either one.
In XP I still use Office 2003, and in some Excel workbooks I use DTPicker2 without any problem. But when I open the workbooks in Windows 7 using Excel 2007 the DTPicker2 control doesn't work, an error message pops up "Object doesn't support this property or method". This happens when I click the macro button that activates DTPicker2. Even before that, the control has no date but a red big X on its place.
After some research, I found out that DTPicker2 is no longer part of Microsoft Command Controls, so it must be manually installed. Following Microsoft instructions, I downloaded mscomct2.ocx and copied it to \Windows\System32. Then I tried to register it using "regsvr32 mscomct2.ocx" and it failed with the message "The module mscomct2.ocx may not be compatible with the Windows version you're running. Check if the module is compatible with an x86 (32 bit) or x-64 (64 bit) version of regsvr32."
It seems I can´t install this ActiveX control in Windows 7. However, I read posts of Excel users who are running DTPicker2 on W7 without problems. And also running DTPicker2 with Excel 2007 without trouble.
The MS site when the module can be downloaded doesn't give a clue about installing it on W7. I don't have any idea on how to check wether it is 32 or 64 bit, but I guess it must be 32...
I know this question is more about W7 then Excel, but as I can't find any help on W7/Excel/DTPicker2 and I assume that other members of this forum might also have had this problem, I'm asking for help, if anyone has a clue on how to solve the problem, considering the use of DTPicker with Excel 2007 and with Windows 7, and also that I removed the module from Windows XP System32 to prevent any possible conflict, but to no avail, so I installed it again, and it still works fine with Excel 2003 on Windows XP.
Also, I really need DTPicker2, not Calendar Control or similar modules. It has a nice drop-down feature and... I would have to change many scripts to replace it with anything different.
Thank you for any help.
MrDoc
I have a dual OS, so I can chose from boot manager if I want to run Windows XP or Windows 7. Each of them is installed in a different HD and I have no problems at all running either one.
In XP I still use Office 2003, and in some Excel workbooks I use DTPicker2 without any problem. But when I open the workbooks in Windows 7 using Excel 2007 the DTPicker2 control doesn't work, an error message pops up "Object doesn't support this property or method". This happens when I click the macro button that activates DTPicker2. Even before that, the control has no date but a red big X on its place.
After some research, I found out that DTPicker2 is no longer part of Microsoft Command Controls, so it must be manually installed. Following Microsoft instructions, I downloaded mscomct2.ocx and copied it to \Windows\System32. Then I tried to register it using "regsvr32 mscomct2.ocx" and it failed with the message "The module mscomct2.ocx may not be compatible with the Windows version you're running. Check if the module is compatible with an x86 (32 bit) or x-64 (64 bit) version of regsvr32."
It seems I can´t install this ActiveX control in Windows 7. However, I read posts of Excel users who are running DTPicker2 on W7 without problems. And also running DTPicker2 with Excel 2007 without trouble.
The MS site when the module can be downloaded doesn't give a clue about installing it on W7. I don't have any idea on how to check wether it is 32 or 64 bit, but I guess it must be 32...
I know this question is more about W7 then Excel, but as I can't find any help on W7/Excel/DTPicker2 and I assume that other members of this forum might also have had this problem, I'm asking for help, if anyone has a clue on how to solve the problem, considering the use of DTPicker with Excel 2007 and with Windows 7, and also that I removed the module from Windows XP System32 to prevent any possible conflict, but to no avail, so I installed it again, and it still works fine with Excel 2003 on Windows XP.
Also, I really need DTPicker2, not Calendar Control or similar modules. It has a nice drop-down feature and... I would have to change many scripts to replace it with anything different.
Thank you for any help.
MrDoc
