How to install Calendar Control 11.0

[Jacob Hilderbrand]

I made a program at work and am using Calendar Control 11.0 with Excel 2003. On one person's PC the calendar looked all messed up and I checked the version and they have Calendar Control 8.0 on their maching, but they are using Excel 2003 as well.

So what file do I need to add so they will have the correct Calendar Control version on their PC (which will hopefulle fix the problem)?

Thanks

[Jacob Hilderbrand]

Ok, I figured it out.

The file is MSCAL.ocx if anyone else was wondering. For some reason the other PC had 8.0 even with Office 2003 installed, so I am not sure how that file is installed automatically.

I removed the old ocx and replaced with the 11.0 version and everything is working.

[Richie(UK)]

Hi Jake,

You've correctly identified the relevant file - MSCAL.ocx. Glad you got it sorted. :)

From memory the problem arises because the control isn't a part of Excel - its typically installed with Access. So the version of the file may well depend upon the version of Access that the users have.

This particular control seems to cause no end of problems one way or another. For people with missing controls you may have some luck here (http://www.fontstuff.com/mailbag/qvba01.htm). For those seeking an alternative you might like to consider Tushar Mehta's add-in (http://www.tushar-mehta.com/excel/software/vba_calendar/) or there are a few at OzGrid (http://www.ozgrid.com/forum/showthread.php?t=22194&page=1&pp=10&highlight=calendar+phil).

[Jacob Hilderbrand]

Thanks Richie, Ill take a look. The Office version is 2003 across the board. The Windows version was 2000 so maybe that had something to do with it?