Date and time picker control - easier way to install

[danaya]

Hello All-
I use this forum all the time for information, but rarely post questions.. That may change as I'm working on a project that is perhaps slightly above my ability.

Here is my problem: I'm building a custom user form that relies heavily on the Date and Time Picker control (MSCOMCT.OCX). I have used this control in the past and noticed it was not available under the references on my machine and went through the hassle of installing it (I'm running Windows 7 64 bit and excel 2007). The way I installed the control is:
1) download the control and place in the sys32 folder or wow64 folder
2) run regsvr32 and the path to the control from the command prompt

I'm trying to train their IT guy to do this, and he is rightfully slightly nervous about tinkering with those folders.

I think at one point installing MDAC version XXX would automatically install this control. Is there something similar? Any other ideas? Although it makes me feel very powerful to drop controls in sacred folders and type commands at the DOS prompt, there must be an easier way.

Thanks for your help.

 

[martindwilson]

you should be able to write a batch file to do it

 

[danaya]

So would the batch file look at the version of windows, then determine the best folder to register the control, then register it? I guess it would also have to check whether the user has admin rights on the machine.

 

[martindwilson]

yep! i have seen some but dos is not my forte, you need to search for it, its not really an excel problem as such

 

[Toonies]

Hi you might find this helpful

http://www.vbforums.com/showthread.php?t=642937

or this

http://www.ehow.com/how_6855314_add-time-picker-excel-2007.html

 

[Toonies]

This may also help you

http://social.msdn.microsoft.com/Forums/en/sbappdev/thread/91cf3127-70fe-4726-8a27-31b8964430c5

 

[Toonies]

or this

http://angrybyte.com/windows-hacks/mscomctl-ocx-for-64-bit-windows-7-vista/