Calendar Control

[Kelly]

Please don't just refer me to the standard calendar-
control info..... have a read first....Thank-you


I have developed many templates that our company uses. I
use Office 2000 Premium. Some of the users don't have
premium and so they don't have Access and thus they do not
have the standard calendar control. It is not currently an
option to install and register the control on each PC.

The way we share the templates is I place them in a shared
drive for them to access.

I think I have explored all my options but maybe one of
you VERY INTELIGENT people can suggest other ideas that I
may be able to give the user a more simple method to
choose dates when using templates.

One idea I had was to place the calendar control in a
shared drive as well but then I think I would need to add
code to my templates that ensured the control was
registered to each users pc before it would work.

Is this a true statement? If so would that be a difficult
thing to do?

Are there other types of controls or other ideas that I
could somehow attach as a part of the template itself so
that the user could select dates without the object
installed in their PC?

As always very appreciative......THIS GROUP IS GREAT!

Kelly

 

[Mark Rosenkrantz]

Kelly;

On my system the calendar control (mscal.ocx) is in :

C:\Windows\System32\mscal.ocx

I think that whoever needs to use this control must be able to set-up a
reference to the control in a commonly shared directory.

You must then set-up the reference to that Calendar control in VBA by doing
this :

In the VBE Menu choose : Tools | Reference

You get a list of checkboxes in which your calendar control is not
available.
Choose browse and locate the directory in which it is and then it will
appear in the list.
Then check it.
In my view that must be it.

Succes;

Mark.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)

 

[=?iso-8859-1?Q?Fr=E9d=E9ric?= Sigonneau]

Hi

Kelly a écrit :

Are there other types of controls or other ideas that I
could somehow attach as a part of the template itself so
that the user could select dates without the object
installed in their PC?

Ideas :

http://perso.wanadoo.fr/frederic.sigonneau/code/Calendriers/CalFr2.zip
(a single userform to add in your template)

http://perso.wanadoo.fr/frederic.sigonneau/code/Calendriers/BOCalendrierSaisieDate.zip
(a calendar in a commandbar, launched by a command in the cells'context menu.
VBAProject is protected, password is 'zaza')

Sorry, commentaries, if any, are in french. Tell if more explanations are
necessary.

FS

 

[Kelly]

-----Original Message-----
Hi

Kelly a écrit :

Are there other types of controls or other ideas that I
could somehow attach as a part of the template itself so
that the user could select dates without the object
installed in their PC?

Ideas :

http://perso.wanadoo.fr/frederic.sigonneau/code/Calendrier s/CalFr2.zip
(a single userform to add in your template)

http://perso.wanadoo.fr/frederic.sigonneau/code/Calendrier s/BOCalendrierSaisieDate.zip
(a calendar in a commandbar, launched by a command in the cells'context menu.
VBAProject is protected, password is 'zaza')

Sorry, commentaries, if any, are in french. Tell if more explanations are
necessary.

FS
--
Frédéric Sigonneau [MVP Excel - né un sans-culottide]
Gestions de temps, VBA pour Excel :
http://perso.wanadoo.fr/frederic.sigonneau
Si votre question sur Excel est urgente, évitez ma bal !

.
WOW, this look like exactly what I want.....I think?

BUT I can't understand a lick of french. Any help is
appreciated but certaily not expected )

Kelly