Add In MS Date Time Picker missing for XL 2010

Topic

New Reply

My IT dept decided NOT to install the add-in for the MS Date Time Picker control. I have a program that I wrote that allows users to choose a date on a calendar… is there any kind of work around that I can include a calendar selection process WITHOUT the DTPicker?

Dennis K

Reply | Quote

Replies

If you have the privileges to do so, extract both files form the cab file (mscomct2.ocx and mscomct2.inf) into the C:/Windows/system32 folder. Go to http://support.microsoft.com/kb/297381 and download the file. Click on the Start orb and type CMD in the search box. From the list above it, right clickCMD and select Run as administrator. Select Yes to run the program is prompted by the UAC. In the command box type without the quotes

“regsvr32 mscomct2.ocx” and press enter. The following message will appear
37608-mscomct2

Close the command window and you are good to go.

To use the control see this post

http://windowssecrets.com/forums/showthread//150068-Excel-2010-Date-Picker?p=877333&viewfull=1#post877333. There are other alternatives posted in that thread that might help.

HTH,
Maud

Reply | Quote

In 64 bit Windows I had to do the above in c:windowssyswow64 directory.

Reply | Quote

Thanx so much but this is not an option… IT dept won’t allow permissions to do that. I did find a possible workaround over at Ozgrid that I will try.

Reply | Quote