CODEWITHSUNDEEP
comvstoadd-in
Stuart
Stuart

Reputation: 21

Building a Com addin for Office 2000 / Office 2007

I am struggling to find a straight forward guide to creating office addins using VSTO and VB.net.

Specifically I would like to know how to be able to create a addin/ dll which can either be referenced from VBA in the form:-

Addin.method(argument) or Addin.property = X

Or which would install its own custom toolbars/ ribbon interface to an aspect of office for example Word.

I've checked MSDN and in terms of legibility and usability of the explanations I have drawn a blank so far.

I currently have a requirement to create at least one addin for Office 2000 to run and manipluate SQL and then a suite of addins for a customized Office 2007 (Word) set-up.

Upvotes: 0

Views: 347

Answers (2)

Stuart
Stuart

Reputation: 21

Got this working :-)

Using a class libary project and ComInterface / ClassInterface.

Upvotes: 0

Sheng Jiang 蒋晟
Sheng Jiang 蒋晟

Reputation: 15261

Adding global named items to the script engine from VBA code requires the script engine expose itself via IActiveScript::AddNamedItem. I doin't think Microsoft would do it anytime soon as this could break existing VBA code.

Upvotes: 1

Related Questions