Results 1 to 9 of 9
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    uses for Office Developer (Excel/Word VBA)

    I write a lot of Excel VBA applications (large and small) and have heard of the MS product called Office 2000 Developer. I've read the description but still not sure what is it for. Is this to create my own apps that have their own VBA language in it? I know that Visio and AutoCAD were developed like this so I'm just asking for clarification about what I could do with the Office Developer package that I can't do with regular Excel VBA.

    The MS description says:
    "Microsoft Office 2000 Developer is the edition of Office designed specifically for developers building and deploying these solutions. Office Developer includes Microsoft Office Premium as well as professional productivity tools, documentation and sample code for quickly building solutions with Microsoft Office."

    I'm still not clear on what more it buys me. <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Deb <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel/Word VBA)

    Deb,

    A couple of extras I've used are Sourcesafe (a very good way to keep track of versions of the same documents); Code Librarian- allowing you to store snippets of code in a database; the facility to automatically create error handling in code.

    There's a fuller list <A target="_blank" HREF=http://www.microsoft.com/office/previous/developer/2000Tour/Datasheet.doc>here</A>.

    In Australia, a very good reason to get developer was that it did not have the registration wizard process of other editions of Office <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel/Word VBA)

    Thanks for the link, it was definitely useful. I've used SS for my C++ apps but not for my Excel VBA files. I'll read up more on the Office Developer and see if I might start using that for my Excel applications instead.

    Thnx, Deb <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

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

    Re: uses for Office Developer (Excel/Word VBA)

    The benefits of Developer depend on which version of Office you're talking about. Office 2000 and later give you a bunch of goodies that are useful even to non-Access developers, like Code Librarian, a developer's edition of SQL Server and Exchange Server and a fully working copy of VSS. Earlier versions primarily gave you the license to distribute the Access runtime, along with a stub for VSS if it was already installed on your system. All of them include Access itself, which isn't part of some other versions of Office
    Charlotte

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel/Word VBA)

    FWIW the Code Librarian is very definitely "all singing, all dancing", although the database for it (and its structure) is very firmly locked down. There was a slightly earlier freeware Code Librarian, which did much the same thing (without the colour coding) available; including a released source code version. The built-in snippets were, naturally, not off the MS production line. I haven't checked to see whether it's been updated. The zip file (for either version) is over the limit for posting here.
    Gre

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

    Re: uses for Office Developer (Excel/Word VBA)

    Are we talking about an earlier version of the VB app that Microsoft included with Developer or some other Code Librarian? The MOD version works as a standalone or as an add-in for any of the Office 2000 apps and VB6. I really miss mine at the office, where I'm forced to struggle along with Access 97 until I get a chance to install XP Developer. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  7. #7
    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: uses for Office Developer (Excel/Word VBA)

    I've actually never used all the terrific extras described here, but I do use Access and FrontPage, so it wasn't a big step up from the Premium edition. The MSDN archives are helpful when I want to do some offline research. Occasionally I use one of the extra controls that I otherwise would have to buy VB to get. Recently I created my first DLL add-in (for Outlook), and learned the basics of the package and deployment wizard; it was all very exciting. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel/Word VBA)

    Sorry for the ambiguity. We're talking about "some other" Code Librarian - without the "drop-in" code feature. (Its main adavantage is that you can re-slice and re-dice the filing tree any way you like.)

    Are there issues in integrating the MS Code Database that ships with XP Developer with an existing 2000 Code Database? If there are, does it get messy if, during a period of integration, you end up having to work with the two databases in parallel?
    Gre

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

    Re: uses for Office Developer (Excel/Word VBA)

    I don't have XP developer yet at home (waiting for the promised hotpatch for Access 2000 so I can run both), but I wouldn't think so. Both are written in VB6, so I would imagine that the only difference is the look and feel and some of the included code. I save all my personal code in my own CodeLib database (one of the nice features is that you can create your own libraries and open the one you choose), and I should be able to open that library just as well from the XP Developer version of Code Librarian as from the Office 2k version. You could simply copy the existing CodeLib.mdb with a new name before you install XP Developer to preserve the Office 2k version.
    Charlotte

Posting Permissions

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