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 (all))

    Please unconfuse me <img src=/S/confused.gif border=0 alt=confused width=15 height=20>.... I want to create a DLL such that it contains code that I can call from my Excel appilcations. I want to try and eliminate the VBA I currently use behind my Excel apps and put it in its own package and use Excel for the GUI portion (presentation part, code is for logic/business rules, etc.). I'll then create a setup.exe with the .xls and .dll file for the end user.

    I thought I could create this DLL from the Office Developer Kit but it doesn't look like that. Do I need VB or .Net to do this (I do have .Net but haven't created any serious programs with it yet). I installed the Office 2000 Developer Kit but it's really a suite of organization tools as I call it (deployment helper, code librarian, etc.)

    Deb

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

    Re: uses for Office Developer (Excel (all))

    There may be confusion about terms here - there is an Office Resource Kit (ORK) and an Office Developer Edition (ODE). The latter can be used to develop COM add-ins (for Office 2000 and higher, Office 97 didn't have COM add-ins.) See HOW TO: Create Office COM Add-Ins by Using VBA and Office Developer.

    Others will probably offer more in-depth help.

  3. #3
    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 (all))

    Just adding to Hans' info, the Office 2000 and Office XP Developer Editions are pretty much self-contained. You do not need Visual Studio to create COM Add-ins for Office (but you would for stand-alone DLLs or EXEs).

    If you are using Office 2003, there is no more Developer Edition. I'm not clear on exactly what parts you need to build COM Add-ins, but what Microsoft would like for you to do is to buy Visual Studio .Net and Visual Studio Tools for the Microsoft Office System, Version 2003 (aka VSTO). Perhaps you could get away with something less... or if you have MSDN Universal, that would cover it all.

  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 (all))

    ACtually, you can install VSTO without installing VS.Net. It includes a standard version of VB.Net.
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel (all))

    I would suggest creating the DLLs with VB 6 as that gives you secure code.
    VB .NET code is not secure and could not be used with all Excel versions.

    I create VB 6 DLLs that can be used will Word 97 and up and/or Excel 97 and up.
    Indeed, using VB 6 allows one to bypass some of missing features in Office 97 VBA which is based on VBA 5.

    If you do not already have VB 6, you better hurry to get it.
    Officially, V B6 is no longer being sold, however, as of a few daze ago, at least http://www.atomicpark.com and http://www.vbxtras.com/ were still selling the critter.
    Check at http://www.pricegrabbers.comto see who is still selling VB 6.

  6. #6
    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 (all))

    According to <!mskb=238228>Microsoft Knowledge Base Article 238228<!/mskb> - which includes a worked example, Office 2000 Developer Edition is sufficient on its own for building a COM Add-In. HTH
    Gre

  7. #7
    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 (all))

    Thanks all for the great posts. I am now officially unconfused. <img src=/S/bow.gif border=0 alt=bow width=15 height=15> In my case I want a DLL not a COM add-in since I don't want to require the user to install the add-in (I can't do that for them can I?) With the DLL I can use a setup.exe to register it and then when they run my Excel file, the code will just call the methods in the DLL instead of the VBA in the Excel file. Now that I'm saying this, it's not quite true as I'd still need some stub VBA code in the Excel file to at make the calls to the DLL methods. The advangage of doing the DLL is to add another layer of obscurity to hide the code (not the calls to the code though).

    I have the MSDN collection so I have all the software I need to do this project. I just have to experiment and see which one works best.

    Thnx,
    Deb

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uses for Office Developer (Excel (all))

    Most of the time, a COM add-in is not needed, or even effective, a DLL is more useful in most cases.

    Using VB 6 is usually a better approach then using Office Devo edition,

  9. #9
    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 (all))

    Just as a footnote for anyone sorting through this, you can create a setup.exe file from the Office Developer Edition 2000/XP using the "package and deploy wizard." The most confusing part is how the button users have to click to install is a gigantic button with a picture on it separate from all the other buttons. That always bothered me.

Posting Permissions

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