Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    ActiveX controls (XL 2003)

    I have an Excel workbook/application where I use Microsoft's calendar control so that the users can easily select a date. That used to work fine, but lately a numbers of users are getting errors (object not available on this machine). Some forced updates in corporate's logon scripts are removing certain ActiveX controls. Does anybody know if it's possible to embed the control into the .xls file at all? - so that I don't have to distribute controls as problems arise... and then teach people how to register them. Since I have over 250 users spread around the world, it would be much preferable. TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX controls (XL 2003)

    The Calendar control uses an external file mscal.ocx to provide its functionality. You can't embed this in your workbook.

    As an alternative, you could use a calendar created as a userform - see for example Userform Calendar Control or Orlando's VBA and Excel Site (free download of popup calendar for Excel).

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: ActiveX controls (XL 2003)

    Hans,

    Many thanks. You were right about mscal.ocx, of course - that *was* the control that I have had to start e-mailing to people (along with instructions regarding regsvr32). The Userform Calendar Control is very clever/creative, e.g., using command buttons for each day and then the ControlTipText property to store the composite date. I didn't look at your other link yet.

    Administrative question: I didn't get an e-mail that you had posted a response. I checked my profile, and my e-mail address is set up correctly. So I'm guessing that I need to add the Lounge as an approved sender somehow (although I *do* successfully receive the Office Watch newsletters). Any idea what exactly I need to do to let the Lounge e-mails through?

    Thanks again,
    Colin.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX controls (XL 2003)

    Please go to Edit email notifications and turn on the option "Do you want all replies to posts that you make emailed to you?", then click "Submit".

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: ActiveX controls (XL 2003)

    Hans,
    I've been meaning to get back to this but keep forgetting. I needed the Calendar Control on an existing userform, so I made adjustments to the "Userform Calendar Control" that you sent me the link to. It's basically the same idea, of course, but I also tidied it up a little.
    Anyway, in case you think it might be helpful to others, I thought I'd send it to you.

    Regards,
    Colin.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX controls (XL 2003)

    Thank you. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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