calendar userform
 

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

calendar userform
 

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

"peter" skrev i melding
...
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

calendar userform
 

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" wrote:

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

"peter" skrev i melding
...
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

calendar userform
 

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

"peter" skrev i melding
...
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