Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Additional Controls (VBA Office 2000)

    Hi.

    I'm developing an application in Excel 2000, and would dearly love to be able to use the grid control on a form. Regrettably, not being blessed with Office Developer Edition, the control is "not properly licensed", and so I can't. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    It's only a small grid that I want, so I can mock it with text boxes and labels if necessary, but the question is:

    Is there a way in which I can register individual additional controls as and when I use them, without having to buy developer edition? Otherwise, why does Microsoft include them in my Premium Edition? (OK, so that's two questions)

    Regards

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    And both are good questions. I wish I knew the answer to them as I have been there. Have you tried shopping the net for controls?

    Maybe somebody else has a grid control. Though I doubt you'll find one <A target="_blank" HREF=http://www.mvps.org/ccrp/>here</A>, you might like to look around.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    Stuart,

    Are you sure Microsoft included the grid control in Office Premium ?. I doubt it as I think it is only provided as a development tool with either VB or Office Developer. If you had to add it manually to the controls toolbox available to VBA, it means it was most likely not provided with office. You may have come to have a copy of it if you installed an application which uses it. It would then need to be registered on your system, but not licensed for development use.

    I do not think there is a way to register the control in question without having a licence for either of the development enviironments with which it is packaged. There may be freeware/shareware equivalents available on the web.

    Andrew C

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional Controls (VBA Office 2000)

    It may very well have been in the list even though no license was provided. I seem to remember some of the controls showing up in the ActiveX list in earlier versions as well, but you couldn't do anything with them unless you had VB Pro or the Developer edition of Office.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    While I might have installed it separately, I'm pretty sure it came with Office - like Charlotte, I saw it in Office 97 as well.

    I guess it's possible that Microsoft put run-time licences in Office so that we humble mortals could all use the whizzy applications developed by those folk with the developer licences, but even so it's not very helpful, IMHO.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional Controls (VBA Office 2000)

    It's more like putting the capability there to be unlocked by a developer license of some kind. When you install the developer tools, they don't include the controls, only the license to use them in projects.

    When a developer creates and distributes an application, they include both the control and the license with the app. Otherwise, there's no way to insure the version they used will be available on the target machine.
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    Charlotte,
    <hr>they include both the control and the license with the app<hr>
    That licence does not include the right (or ability) to develop with the control, does it ?
    If it did it would be a good method of distributing the controls to all and sundry.

    Andrew

  8. #8
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Additional Controls (VBA Office 2000)

    The weirdness of it all was further explored in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=vb&Number=72753>Post #72753</A>.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional Controls (VBA Office 2000)

    No, the disributed license allows you to use an app with the control in it.
    Charlotte

  10. #10
    Star Lounger
    Join Date
    Aug 2001
    Location
    GA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    How about a grid control you can use for Free. <A target="_blank" HREF=http://www.stinga.com/beegrid/>http://www.stinga.com/beegrid/</A>
    It has some limitations on the free version but you said your grid was small (I'll asume you are refering to the row count) so this may work for you. They say it supported in vb so it should work OK in Excel. I haven't tried it so your on your own to investigate.

    Later,
    Bruce

  11. #11
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    Bruce,

    Nice control, although it is more database than spreadsheet focussed. Thanks.

    Stuart

  12. #12
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    Interestingly, there are a number of other ActiveX controls that you can appear to use. I'm not sure how many of these came with Windows & Office, and how many I've picked up from elsewhere, but they are registered on my machine and I can include them in applications.

    For example:

    Microsoft Spreadsheet Control
    Media Player control
    HyperlinxAX.control
    Microsoft Date & Time Picker control version 6
    Status Bar control version 6
    Progress bar control version 6

    plus a host of others.

    Now, I often appear to have two versions of a lot of the Microsoft controls (usually shown as version 5, which I can't develop with, and version 6, which I can). I, as a humble developer, have no way of knowing what licences I'm signed up to. I can only assume that since the control is available for development, I am allowed to develop with it.

    The only drawback is that I have no way of knowing whether the target machine would have it or not, but I can overcome that with testing, as my particular applications have extremely limited target machines (less than five, in fact).

    What do you think?

    [Edit] PS, I don't have any other development tools, so I've not installed these as part of VB6, say, or any other toolset. At least, not conciously.

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional Controls (VBA Office 2000)

    Do you have VB6 Professional? It comes with a development license for various controls, including the common controls. If you have VB Pro or Office Developer, you can package and deploy an application that includes those controls *and* their runtime licenses. When the setup is run on the target machine, the controls should be installed and registered. Watch out for some of them, though, if the target machine might have a later version installed.
    Charlotte

  14. #14
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Additional Controls (VBA Office 2000)

    Nope. Quite emphatically not.

    At least, as I said, not consciously - the only way that they would have got there other than via Microsoft is if A.N.Other application had put them there. I've never, ever installed VB6 (although I have some recollection of seeing VB6 runtime installing as part of something, although don't ask me what).

    The question still is, though - if I can develop with them, am I licensed to re-distribute them, even if I don't know how I got them?

  15. #15
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Additional Controls (VBA Office 2000)

    No. Even if you can use the MS activeX controls on your machine, you don't have a license to redistribute them unless you have the Office developers edition, VB Pro or Visual Studio. It's purchasing those versions that buys you the redistribution rights.
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

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