Confused on MS Products to Create COM addin

[Bill Bell]

Daniel, thanks for the info. I was looking on MS web site for Office
Developer about product to create COM addins and I am confused on what
product to purchase. I need the COM addin to work in Office 2000,
Office XP and Office 2003. They have references to:

0 Microsoft Office XP Developer - but it appears that product
is discontinued.
0 Visual Studio Tools for the Microsoft Office System. This looks
it will create a COM addin.
0 Visual Studio .NET 2003 - This sounds that whatever it produces
will only work with Office 2003.

Any help in clarifying the confusing MS marketing material is appreciated.

 

[Michael Hopwood]

If it creates a COM component it should be compatible with any product that
supports COM.

That's the sales-pitch anyway.

This thread appears to be a bit broken up, I can't see the original post,
what are you trying to do?

Daniel, thanks for the info. I was looking on MS web site for Office
Developer about product to create COM addins and I am confused on what
product to purchase. I need the COM addin to work in Office 2000,
Office XP and Office 2003. They have references to:

0 Microsoft Office XP Developer - but it appears that product
is discontinued.
0 Visual Studio Tools for the Microsoft Office System. This looks
it will create a COM addin.
0 Visual Studio .NET 2003 - This sounds that whatever it produces
will only work with Office 2003.

Any help in clarifying the confusing MS marketing material is appreciated.

 

[Bill Bell]

I am trying to provide better protection of the VBA addin than is
provided by the password protection capability. My understanding is you
can convert it to a COM addin using something like MS Office Developer.
I do not see that product listed on the MS website so I was asking
about which product would be best to use. I need the COM addin to work
in Office 2000, Office XP and Office 2003. I wanted some user
experience on which product to purchase.

If it creates a COM component it should be compatible with any product that
supports COM.

That's the sales-pitch anyway.

This thread appears to be a bit broken up, I can't see the original post,
what are you trying to do?

 

[Daniel Klann]

Bill,

You can get Office XP developer from all over the place e.g. you can get it
for £330 here:
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=3636386634&category=184

You could also get Visual Basic 6 which would not only let you create COM
addins but also stand-alone executables. The advantage of using Office
Developer is that you won't need to recreate your forms (if you have any),
whereas you will need to recreate everything from scratch using VB6. These
addins will work with 2000 onwards.

Hope that helps,
Dan

I am trying to provide better protection of the VBA addin than is
provided by the password protection capability. My understanding is you
can convert it to a COM addin using something like MS Office Developer.
I do not see that product listed on the MS website so I was asking
about which product would be best to use. I need the COM addin to work
in Office 2000, Office XP and Office 2003. I wanted some user
experience on which product to purchase.