Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Creating COM Add-Ins (Office 2000/2002)

    Does anyone have experience converting Office add-ins into COM Add-Ins? I have several very large add-ins (Excel and Access) that I would like to convert to protect the code and I am trying to estimate the level-of-effort. I worked through the chapters in David Broctor's Microsoft Office 2000 VBA Fundamentals this weekend and felt like I was learning VB all over again (and I'm a MOUS expert/VB instructor!).

    After the learning curve, which things will migrate easily and which things will have to be rewritten? One of my concerns is the fact that the programmers who wrote the current add-ins were just learning, so much of the code looks like the macro recorder, ie no Option Explicit, uses Select & Selection, uses Cell and Range unqualified (instead of app.book.sheet.cells). The biggest add-in has 23 sheets & 11 forms for a total of 200 controls & 9,000 lines of code. I may have to postpone retirement.

    Also any book recommendations? Should I buy Reed Jacobson's Microsoft Excel 2002 Visual Basic for Applications Step by Step and John Walkenbach's Excel 2002 Power Programming with VBA or is there another suggestion? TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  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: Creating COM Add-Ins (Office 2000/2002)

    Gee wiz, Sammy you're blazing the trail here for me.

    Have you got the ODE (Office Developer Edition -- or whatever
    it's called now -- Office XP Developer?)?

    Maybe there's some help in there...

    I always thought those Step by Step books were, well, rather,
    sophomoric, to say the least. But what do i know....
    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
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating COM Add-Ins (Office 2000/2002)

    > always thought those Step by Step books were, well, rather, sophomoric
    <img src=/S/yep.gif border=0 alt=yep width=15 height=15>, but this is the last chapter, and <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> getting old. -- <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>
    but it's the only way to really copy-protect your code.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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