Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2005
    Location
    Wellington, Wellington
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VB, Datepicker controls and OCX files (Excel 2003)

    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.

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

    Re: VB, Datepicker controls and OCX files (Excel 2003)

    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 <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    New Lounger
    Join Date
    Mar 2005
    Location
    Wellington, Wellington
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB, Datepicker controls and OCX files (Excel 2003)

    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.

Posting Permissions

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