Need help! Exel 2007 and 2010 conflict!

[Reemet]

I have done exel in vba and there is a userform where is a date and time picker that is {MS Date and Time Picker 6.0 (sp4)} with is not in MS exel 2010.
That server run in win 64bit OS system and i could not get it work!
I have done:
download file MSCOMCT2.OCX
used bat file to place it to the right folder and add it to the system registry but still not working!

Problem is that i have users how run the file in office 2007 with is working perfectly and some users are using ThinClient to connect server where is Office 2010 and then the problems begin!

Please, can anyone help me with this?!

Best Regards

Reemet

[Reemet]

MSCOMCT2.OCX Together regsrv32 %WinDir/syswow64/MSCOMCT2.OCX

[buran]

Hi,
in which folder do you place the ocx file? in 64-bit OS it's not system32 folder. I think it should be in SysWOW64.
Just a wild guess...

[buran]

we post at the same time. so it's in the right folder...

[Reemet]

I can make a try!

[Reemet]

It is not work!

[Reemet]

Any more suggestions?

[Reemet]

I have made a test with 32bit office 2010 and there the method works!
Please if anyone know what to do to get it work in exel 2010 64 bit then, please help me!

Regards

[Izandol]

It is not possible with 64bit Office. There is no 64 bit version of Windows Common controls: http://office.microsoft.com/en-us/su...in=HA010369476

[Reemet]

OK that's sad!

I add the picture of form and id like to use a working object that i can replace with the MS DTPicker 6.0 (SP4) so it can be usable in 32 bit 2007 and 2010 and in 64 bit 2010 versions!
Will you have some ideas!

The value of the object is Date and Time! Custom format "dd.MM.yyyy HH:mm"

[Izandol]

It is probably simpler to use two textboxes for date and time and validate on exit. Using DTPicker in this format is not much more than textbox anyway.

[Reemet]

I did us a textboxes in the beginnig but it did not work properly!

First i had issue to Format value in it!
Second i needed to validate the values between textboxes and then the user must be acurate
and it did tuc time twices more then the object DTPicker with is 100% secured the value formating!
[link]
http://www.excelforum.com/excel-prog...ml#post3566124
[/Link]

[Izandol]

It is more code but it will work. I have put answer in the other question why your code will not run.

You may like to create calendar form with combobox controls for day, month and year as well as for times.