Excel Hints

Results 1 to 4 of 4

Thread: Solved: How to install Calendar Control 11.0

  1. #1
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,660
    Location
    Blog Entries
    7

    Solved: How to install Calendar Control 11.0

    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

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,660
    Location
    Blog Entries
    7
    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.

  3. #3
    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. For those seeking an alternative you might like to consider Tushar Mehta's add-in or there are a few at OzGrid.

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,660
    Location
    Blog Entries
    7
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •