Results 1 to 5 of 5

Thread: COM Addin (O2K)

  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    COM Addin (O2K)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    A couple of years ago, I attended the ODDC and COM Addin's were the hot topic.(Along with that Access workflow designer thing that didn't seem to go anywhere.) COM Addin's sounded like a pain in the you know what. They were very difficult to debug and tricky to get working. Have they improved over the last couple of years? I haven't had the need to use them. I can't think of any time where a COM Addin would have been better than a Application Specific Addin. I've never had the need to have similar functionality across Word, Excel, and Powerpoint... Maybe the Office related projects that I work on aren't a big enough to warrant COM Addins. What are your experiences with COM Addin's?

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COM Addin (O2K)

    What a timely question <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I have written an Add-In that will list all the declared VBA variables in a VBA project. Currently I have to maintain 5 separate version (W97, XL97, W2K, XL2K and A2K), all in the native file format of the application.

    I am, as we speak, looking at the MSDN site to see what it will take to convert this to a COM Add-In, so I only have to maintain 1 version, possible 2 (Office 97 and O2K).

    Hopefully <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>, it won't be too much.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  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: COM Addin (O2K)

    We use a COM Add-in for Outlook. The logistics of distributing VBA solutions for Outlook are otherwise prohibitive. Maintenance has not been a big issue: I'm just leaving some minor things broken until more people complain. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> But seriously, debugging was more arduous than usual, and it left dozens of apparently useless entries in my registry from all the reinstalls. I haven't cleaned them out yet, since I don't know which ones matter... from the end-user perspective, the Office 2000 version seems to work fine with Outlook 2002. Unfortunately, I wasn't able to make it work with WordMail...

    Afterthought: This was done in Office 2000 Developer, not VB. I have no idea how it would differ with VB.

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

    Re: COM Addin (O2K)

    Only Office 2000 and Office XP support COM Add-Ins.

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

    Re: COM Addin (O2K)

    COM Add-Ins have, from my view, the following advantages over using a VB created ActiveX DLL:

    1. With a COM Add-In, you can more easily tweak the code to work in more than one app, say, Excel and Word.

    2. A COM Add-In protects ALL the code. Using a VB created DLL, the only code that is protected is the code included in the DLL. Unless, you code the VB DLL to use, say, Excel via Automation, the Excel dependent code is not protected as securely as the code in the DLL.

Posting Permissions

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