Question

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.

Answer 1

Got this working :-)

Using a class libary project and ComInterface / ClassInterface.

Answer 2

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.

友情链接