Excel 2003 Datepicker functionality without Install

I'm building a form on Excel 2003 for clients whose IT department enforces restrictions on what their users' can do with their computers.  The clients don't have access to modify their system32 folder or make changes to their registry.

They have requested that the date fields be controlled by a datepicker interface.  I'm aware of a solution that involves placing an .ocx file in the System32 folder and updating the registry.  Is there a solution to this issue that would accommodate the client's restrictions but allow similar functionality?
VanirMISAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TommySzalapskiCommented:
Have you tried the Microsoft MonthView control? Unless they are using an odd custom install of Office it should be in there already. I always use it over DTPicker for that very reason.
0
TommySzalapskiCommented:
That said. You could use your previous solution and just put the ocx somewhere other than the system32 folder. You would just have to type the whole path in the regsvr32 line. They might not have permissions on the LOCAL MACHINE registry hive, but they have to be able to change their CURRENT_USER one or almost no major applications will work properly. They might be able to register the ocx for just their username.
I would still use the MonthView control though.
0
VanirMISAuthor Commented:
Thanks for the suggestions.  I decided to pursue your original suggestion since it's the route that requires the least support.

I didn't find a MonthView control, but after further research I found that by setting a reference to Active Setup Control Library a reference was also set to Microsoft Calendar Control 11.0 which allowed me to place a similar control (Calendar Control 11.0) in the spreadsheet form.  I will have to verify that this works with the client, but in case they have a similar set up to yours,  I would still like to know if there's a reference I need to set to have access to the MonthView control.  I wasn't able to find a corresponding reference.  I am currently building the form on Excel 2003 SP3.
0
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

TommySzalapskiCommented:
I hit 'More Controls' and I scroll down to 'Microsoft MonthView Control 6.0.' It's right before all the Microsoft Office ... controls.
0
Rory ArchibaldCommented:
The MonthView control is part of MSCOMCT2.ocx I believe.
0
VanirMISAuthor Commented:
Thank you both for your responses.  I'm going to stick with Calendar Control 11.0.

Microsoft support verifies rorya's statement that MonthView is part of MSCOMCT2.ocx (http://msdn.microsoft.com/en-us/library/aa276348(v=vs.60).aspx)

And since MSCOMCT2.ocx is no longer included with Microsoft Office XP Developer (http://support.microsoft.com/kb/297381) I'll have to avoid this solution.

Again, your input is very much appreciated.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VanirMISAuthor Commented:
After doing my own research I found that the MonthView control is no longer included in the standard Excel 2003 install.  Rorya somewhat verified this fact and his claim was confirmed by Microsoft.  However, TommySzalapski and rorya's comments set me on the right path to find my answer; hence the B, rather than C rating.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.