Results 1 to 8 of 8

Thread: Alternative to MSCOMCTL.ocx

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Feb 2013
    Posts
    1
    Rep Power
    0

    Alternative to MSCOMCTL.ocx

    Hi everyone,

    I'm moving my project from 2010 to 2013 (no other option) and all is working fine but the frmCal, my guess is cause the MonthView Control is missing. Is there anything that replaces it?

    Please advise.

    JC

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    You should have the same control available in Excel 2013. However, the MSCOMCTL.ocx file version might be different, and hence would be throwing an automation error. One way would be to update your form with the latest control, OR (haven't tested that for 2013, but it did work when I had an issue with Excel 2007 service pack change), downgrade this particular ocx file in your computer by registering the older version of this file.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Feb 2013
    Posts
    2
    Rep Power
    0

    Alternative to MSCOMCTL.ocx

    Hi vlc

    Don't have Excel 2013 and don't know what the MonthView Control is. I suspect it's the old Calendar Control from pre Excel 2007. If so this link may be of help
    Non ActiveX Calendar Control

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  5. #5
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0

    MonthView Control & Regional Settings

    I have been using a date picker that is able to work in both office 2007 and 2010 and I find it very handy.
    In my home pc, Office 2010, english regional settings used everything is working great!

    However I use this control in my work laptop that has Greek regional settings (in order to make other apps work) and office 2007.
    The only problem is that the month name is not showing properly... see the pic below...

    Capture.PNG

    If I click on the month name and the drop down list appears with all months then they all show up properly and they are readable.
    I know that I could just change my windows regional settings but this is not an option since other apps installed from my company IT dept will stop working.
    Is there any way to make the specific control show the months always in English like in the pic below?

    Capture2.PNG

    Sorry not to ask in a new thread but since there is a related thread already it seemed proper to post here!

    Mr. Black'd

  6. #6
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/of...controls-1238/
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  7. #7
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Mr Blackd, can you post a sample workbook with this control?
    Here you go... Book2.xlsm
    Note that I have found this online as an alternative to an older date picker form that was working only in office 2007.
    And it does a great job but ... well I described the issue above

    but in order to clarify more I add these two screenshots of the file I attach

    one with the form as seen with greek regional settings
    RS GR.jpg

    and one with the form as seen with english regional settings
    RS EN.jpg

    Quote Originally Posted by Excel Fox View Post
    In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/of...controls-1238/
    I have already seen this form for the date here today but not in detail...

    I will probably use it if I fail to find a solution to my issue.


    And thanks for your reply.
    Last edited by MrBlackd; 07-19-2013 at 10:50 PM.

  8. #8
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Mr Blackd, can you post a sample workbook with this control?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Register / De-register OCX Files Using VBA
    By Rasm in forum Download Center
    Replies: 2
    Last Post: 12-12-2020, 10:55 PM

Posting Permissions

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