PDA

View Full Version : Date Picker Issue



dodonohoe
11-19-2014, 09:33 AM
I am using the "Microsoft Date and Time Picker Control 6.0 (SP6) on Excel 2010 32 bit. The control works perfectly on my own machine. When I deploy to the office to use some of the users are getting an error message "Can't exit design mode because control can't be created."They are running exactly the same as me including windows 7 64bit. Any suggestions as it is driving me mad as to why only a couple of users are experiencing it.

ranman256
11-19-2014, 10:55 AM
Its possible they are missing the control object in the SYSTEM folder.
Look at the path of yours in your VBE menu, TOOLS , REFERENCES.
Make sure they have it too.

GTO
11-19-2014, 09:38 PM
I am using the "Microsoft Date and Time Picker Control 6.0 (SP6) on Excel 2010 32 bit. The control works perfectly on my own machine. When I deploy to the office to use some of the users are getting an error message "Can't exit design mode because control can't be created."

They are running exactly the same as me including windows 7 64bit. Any suggestions as it is driving me mad as to why only a couple of users are experiencing it.

Maybe not of help, but at least at my work, I cannot locate MSCOMCT2.OCX on my PC (WIN7 SP1 64-bit, Excel 2010 32-bit). I believe these controls were depreciated and may not be installed in Office 2010? Also, while you said the other users setup is exactly the same, if this library was installed, you might want to see if by chance, the users with troubles might have had Office installed in 64-bit?

Here are a couple of links you may find interesting:L

https://social.msdn.microsoft.com/Forums/en-US/11be1795-4253-4b6b-95bc-d2f65fc0274b/missisng-windows-common-controls-in-vba70-in-excel-2010-64bit

http://support.microsoft.com/kb/297381

Mark

dodonohoe
11-20-2014, 03:13 AM
HI ranman256. They have this too.

Thanks

dodonohoe
11-20-2014, 03:31 AM
Hi GTO,

No luck with any of those but thanks. I did further testing on one of the machines where I took a brand new workbook and inserted the "Microsoft Date and Time Picker Control 6.0 (SP6). It inserted the Date Picker object but you cant even click on it, it just sits there dead. I then deleted the Control and created a VBA sub with nothing in it. I then tried to re-insert the Date Picker and got the error "Cannot Insert Object"

I have tried the following "solution" but to no avail

We have had a similar problem in the past with an ActiveX control that we insert on an Excel sheet from our COM Add-in, and you seem to have touched on two of the items (below) to solve it. The following solves the problem most* of the time.
From Excel 2010: File ribbon; Options; Trust Center; Trust Center Settings (button)...;


Add-ins: UNCHECK 'Require Application Add-ins to be signed by Trusted Publisher'.
Macro Settings: Ensure it is not disabling all Macros without notification. It is OK if it is set to 'Disable all Macros with notification'.
ActiveX Settings: Ensure it is not disabling all controls without notification. It is OK is it is set to 'Prompt me before enabling all controls with minimal restrictions'. THIS WAS THE MAIN CAUSE.
Trusted Locations: Add the directory of your control.

Toonies
11-21-2014, 01:19 PM
this maybe of help to you

http://www.rondebruin.nl/win/addins/datepicker.htm

dodonohoe
11-24-2014, 01:14 AM
Thanks Toonies, I had seen this one alright. I might investigate it a bit further as the Microsoft Date Picker seems unstable at best. The only issue here is that there are add ins so deploying that to 100 users might not be as easy as I would like.

lucas
11-25-2014, 09:45 AM
This is old but I still use it:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=543

It stays with the workbook.

dodonohoe
11-26-2014, 01:54 AM
This is old but I still use it:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=543

It stays with the workbook.


Thanks Lucas, I will give that a go.

GTO
11-26-2014, 03:21 AM
@lucas:

Hi Steve,

Nice to see you about! I barely "get out" at present, taking care of Mom and all - so it was super-nice to see you post. Happy Thanksgiving and God's best to you and yours :-)

Sincerely,

Mark

EirikDaude
11-27-2014, 06:01 AM
I use this datepicker currently: https://sites.google.com/site/e90e50/calendar-control-class

Not really sure how it compares to the other suggestions you've got here, but I suppose more is always better ;)

soplo
06-23-2015, 06:29 PM
Hi Lucas
I've been searching substitution for date picker and yours is awesome.

But I found a mistake if I choose a date after 2030. It brings into 19xx. I try modify your code.
"m/d/yy" become "m/d/yyyy". It runs well.

Thanks for your code anyway