I am trying to build a Shim for a .Net based add-in for Excel.
My add-in was developed using vb.net 2010 using the shared add-in template which uses mscoree.dll.
I have just been asked to digitally sign the add-in. The shared add-in template creates add-ins that are linked to mscoree.dll which I can't sign so it turns out I have to create a COM shim for the add-in and then sign that.
I have created a shim project using Andrew Whitehapel's COM Shim Wizard for Visual Studio 2010. Unfortunately, it's having a problem importing the type library for IDTExtensibility2.
The following #import statement results in an error:
// Imports the MSADDNDR.DLL typelib which we need for IDTExtensibility2.
#import "libid:AC0714F2-3D04-11D1-AE7D-00A0C90F26F4" raw_interfaces_only named_guids
The error is as follows:
IntelliSense: cannot open source file
This project worked a number of years ago (on a different machine).
I'm running Win 8.1 on a machine with VS 2010 and Office 2010 x64 installed.
I have confirmed the existence of C:\Program Files (x86)\Common Files\Designer\MSADDNDR.DLL. Its file properties list Product version 6.0.8169, Size 84KB, Date modified 6/18/1998.
I did a regsvr32 MSADDNDR.DLL from an elevated command prompt to make sure it was registered.
What am I doing wrong?
Is there a different statement I can use in place of the #import statement I'm currently using?