Building a Com addin for Office 2000 / Office 2007

add-incomvsto

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.

Best Answer

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.

Related Solutions

R – Adding Ribbon support to Excel COM Addin

I havent used OfficeXP, but have built COM AddIns against 2000, 2003 and 2007.

I recently built a COM AddIn for Office 2007 using the IRibbonExtensibility interface, with references to the v12 PIAs.

When I used this with Office 2003, I found it worked pretty well. However, my AddIns is only providing some very basic functionality and not using many calls onto the Excel objects. I adjusted the OnConnection method to set up the CommandBars only if the Applicaiton.Version was less than 12.

There were no code changes that I remember needed to switch from 2003 PIAs to 2007 PIAs. In the past have found you can switch between different versions of the PIAs with minimum effort.

James

Not a valid Office Add In

Excel kept rejecting the Add-In, so the solution for me was doing it directly via the registry.

Save the below text as a .reg file, replace the Manifest path and FriendlyName to suit your PROJECT and double click the reg file to add the key to the Registry.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\PROJECTExcelAddIn]
"Manifest"="file:///C:\\TFS\\Pg.PROJECT\\PROJECTExcelAddIn\\Src\\PROJECTExcelAddIn\\PROJECTExcelAddIn\\bin\\Debug\\PROJECTExcelAddIn.vsto"
"FriendlyName"="PROJECTExcelAddIn"
"LoadBehavior"=dword:00000003
"Description"="PROJECTExcelAddIn - Excel add-in for PROJECT."

Best Answer

Related Solutions

R – Adding Ribbon support to Excel COM Addin

Not a valid Office Add In

Related Topic