• VB, Datepicker controls and OCX files (Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » VB, Datepicker controls and OCX files (Excel 2003)

    Author
    Topic
    #417122

    Nasty question for y’all.

    I have developed and maintain an Excel-based application that is used extensively across my organisation of a few thousand staff. I recently upgraded the application, and changed some of the controls used. I installed a datepicker control that was valid at the time, using a file mscomct2.ocx.

    After starting this, we upgraded to XP, and this file disappeared from all clients. At the same time, the ability for anyone (save power-users such as myself) to write to their hard-drive was removed.

    Now when the application is run, anyone other than myself gets a compile error because the ocx file doesn’t exist. If I release the application together with the ocx file, the ocx file tries to install itself on the user’s hard drive, and fails because of the poxy restricted permissions.

    Questions:
    Is there a generic ocx file that provides a datepicker control? I don’t particularly want to use a calendar control if I can avoid it.
    Is there a way I can edit an ocx file so that it does not self-install? Or any other way of making the ocx file operate from the same public location as the application?

    Is there a way of convincing a large nationwide organisation that their ideas of standardising desktops and servers, and their ideas of what staff should be allowed to do are moronic?

    Many thanks.

    Gravey.

    Viewing 0 reply threads
    Author
    Replies
    • #935034

      Welcome to Woody’s Lounge!

      > Is there a generic ocx file that provides a datepicker control?
      You probably don’t want an ActiveX control.
      > Is there a way I can edit an ocx file so that it does not self-install?
      Not as far as I know.

      However, it is possible to create a popup calendar in a userform. See for example Orlando’s VBA and Excel Site (Site de VBA e Excel do Orlando) (free download)

      > Is there a way of convincing a large nationwide organisation that their ideas of standardising desktops and servers, and their ideas of what staff should be allowed to do are moronic?
      That is beyond the scope of the Lounge grin

      • #935501

        Thanks for that.

        Unfortunately, the complexity of the process means I can’t really have the GUI in the spreadsheet itself – it does need to be a VB userform in order for me to get the controls right.

        One of the components is a glorified compound interest calculator (but displaying to the user every week in the period which can run over several years), splitting as necessary for different rates of payment due (upon which the interest is calculated) – of which there can be dozens.

        We really do make things difficult for ourselves! (sigh).

        Thanks heaps for the info anyway – I am sure I can put it to good use in other areas.

        Cheers,

        D.

    Viewing 0 reply threads
    Reply To: VB, Datepicker controls and OCX files (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: