Help with ActiveX installs (date picker)?

[jsabo]

I am developing a macro for work to keep people on top of "stale" forecast dates. Part of this macro involves the use of "MSCOMCT2.OCX". As you may be aware, this is not standard with Excel these days but it is required for my macro to function properly.

Do you have any suggestions for how to set my macro up for distribution across my company? I am not looking forward to registering "MSCOMCT2.OCX" on each and every company machine so i am wondering how best to go about this? Is it possible to build an ActiveX (http://www.excelforum.com/) Object into the macro-enabled workbook itself (unlikely)? Or am i better off creating an installer (http://www.excelforum.com/) which would dump the workbook onto, say, the desktop (http://www.excelforum.com/)while registering the Object during the install process?

Thanks.

[Kenneth Hobs]

These may help.
http://social.msdn.microsoft.com/Forums/office/en-US/c7ccebe5-5d7f-4fb2-ae16-1438e0e736a4/excel-date-time-picker-calendar-controls-multi-compatible-
http://www.gmayor.com/popup_calendar.htm

You would probably be better off using a Userform as a pseudo datetime picker.

See this for more.
http://www.rondebruin.nl/win/s8/win003.htm