calendar userform

[Guest]

Hi,
I just tried using a userform with a calendar control that works with excel 2002 on a machine with excel 2003. It didn't work. What files need to be in whcih folders to get a calendar control for excel 2003?

peter

 

[Harald Staff]

Hi Peter

I think it's either mscal.ocx (installed with Access and downloadable from
the web, do a Google search) or a licensed mscomct2.ocx (installed and
licensed with Visual Studio).

Allow me to spend some room for some cool lyrics by one of the finest
american composers:

SUNDAY

Sunday?
WOW!
SUNDAY,
'MONDAY

SUNDAY,

SATURDAY. . .TUESDAY THROUGH
- MONDAY'!

SATURDAY. . .

And thus THE CALENDAR,
In all of its colorful disguises
Was presented to
The bored & miserable people
Everywhere!

GREGCERY issued a memo on it.
Whereupon the entire contents
of the Steno Pool
Identified with it STRENUOUSLY,
And WORSHIPPED IT as a WAY OF LIFE,
And took their little Pills by it.
And went back 'n forth from
work by it.
And paid their rent by it,
And before long they were even
having
BIRTHDAY PARTIES IN THE OFFICE
by it,
Because NOW. AT LAST,
CRECGERY PECCARY's exciting new

invention
Had made it possible
For everyone
To find out
HOW OLD THEY WERE!

What hath GOD wrought?

Unfortunately,
There were some people
Who simply DID NOT WISH TO KNOW
---
Best wishes Harald

Hi,
I just tried using a userform with a calendar control that works with

excel 2002 on a machine with excel 2003. It didn't work. What files need to
be in whcih folders to get a calendar control for excel 2003?

 

[Guest]

Hi,
Thanks for the info. Does that mean that if I am running office prof which comes with Access and the control IS available, and the other pc is running office small business ( no MS access) and the control is NOT available, that there is no way to make it available on that pc without installing MS access?

peter

 

[Harald Staff]

Hi Peter

If we talk the Access mscal.ocx, it's legal, free and not too complicated.
Here is a good place to get it (I think, didn't actually run it from here
since I have both Access and Visual Studio):
http://www.fontstuff.com/mailbag/qvba01.htm
or this MS site (it looks very old)
http://www.microsoft.com/officedev/tips/regactx.htm

HTH.Best wishes Harald

Hi,
Thanks for the info. Does that mean that if I am running office prof

which comes with Access and the control IS available, and the other pc is
running office small business ( no MS access) and the control is NOT
available, that there is no way to make it available on that pc without
installing MS access?