You are here: Office-Outlook.com  / Outlook Forum

Problem with a Shimmed excel add-in - Help help help

Home » Outlook addins and plugins development » Developer Outlook add-ins
Problem with a Shimmed excel add-in - Help help help [message #674] Mon, 24 July 2006 13:22 Go to next message
Guilherme - Brazil
Messages: 4
Registered: July 2006
Junior Member
Dear friends,

I’m trying to generate an excel add-in with shim for 2 weeks. It seems to be
easy, but it doesn´t work.

My continuous routine:

1. Install Windows XP Professional SP2
2. Install.NET Framework 2.0
3. Install Visual Studio 2005
4. Install vs2005-kb908002-enu-x86.exe - MICROSOFT OTK LOADER UPDATE TO
MICROSOFT VISUAL STUDIO 2005
5. Install Microsoft Office 2003
6. Install Microsoft Office 2003 SP1
7. Install COMShimWizardSetup.msi – COM Shim Wizards x2.0.0.0
8. Install Office XP or 2003 Primary Interop Assemblies Readme File. It
doesn´t change anything when I´m runnig the sample project.
9. I open the Addin sample solution generated by the COM Shim Wizards
installation. SCREEN CAPTURE( http://www.cin.ufpe.br/~gbs2/shim/2projects.JPG
)
10. I click on the SetupProject propriety, prerequisite and check the
“Shared Add-in Support Update for Microsoft .NET Framework 2.0” SCREEN
CAPTURE ( http://www.cin.ufpe.br/~gbs2/shim/prerequisites.JPG )
11. I tried to generate a strong dll (In the project propriety). Generating
or not generating the addin will fail later.
12. I rebuild the TestAddinSetup and I install it.
13. I run excel.exe and the addin is working
14. I exit from the excel
15. I click on “add a new project” on the solution panel. Select the
COMShims and finally the “Addin Shim Project”
16. Now the WizardSetup is running. I select the generated dll from the
TestAddinSetup. I let the “Use the GUI/ProgID” selected, I select the
“Microsoft Excel”, the “Load addin when the office starts” and the “Addin
available to users”. SCREEN CAPTURE(
http://www.cin.ufpe.br/~gbs2/shim/wizard.JPG ) . The summary is showed SCREEN
CAPTURE(http://www.cin.ufpe.br/~gbs2/shim/wizard2.JPG) .I click the finish
button.
17. I build the ShimProject. SCREEN CAPTURE (
http://www.cin.ufpe.br/~gbs2/shim/3projects.JPG )
18. When I start the excel.
19. There’s a security warning. I click on Enable. (When the checkbox “Trust
all addins” is checked, there isn’t any security warning screen) (The
security was changed to Medium or Low)
20. The excel starts and the addin doesn’t work.
21. Now the excel is broken, if I uninstall the addin and install it again,
the addin doesn’t work. So I need to clear the partition and start this
routine again with few changes.

Anybody could help me??? What I’m doing that this addin doesn’t work??? Is
there any missing step??? Anybody have a step-by-step tutorial??? Or an
example with shim that works?? I read some documentation in MSDN but there´s
no more details from the shim process.

Best regards,

From Brazil,

Guilherme
Re: Problem with a Shimmed excel add-in - Help help help [message #688] Tue, 25 July 2006 06:19 Go to previous messageGo to next message
Guilherme - Brazil
Messages: 4
Registered: July 2006
Junior Member
Hi Michael,

This occurs on all scenarios that I tested:
*on the developer machine(with VS2005 installed) - scenario 1
*in another partition without VS2005 installed - scenario 2
*in another personal computer - scenario 3

Thanks,

Guilherme

"Michael" wrote:

> is this just on a non developer machine? or the on the pc that have
> visual studio installed?
>
> greets from swizerland
> Mitch
>
>
Re: Problem with a Shimmed excel add-in - Help help help [message #695] Tue, 25 July 2006 09:03 Go to previous messageGo to next message
Guilherme - Brazil
Messages: 4
Registered: July 2006
Junior Member
Hi Michael,

There are these references in the setup project without the shim.
http://www.cin.ufpe.br/~gbs2/shim/registrySetupProject.JPG

Should I create another setup project with the generated shim DLL(after the
build on the shim project) and these references in the registry?

Do you have any working shim example ou screen capture of a shim Setup
project??

Thanks again for the help

Guilherme


"Michael" wrote:

> Hi Guilherme,
>
> does the Add-In exist in the "COM Add-Ins" window in Excel? and is it
> checked?
>
> if not, setup is missing some registry entrys..
>
> something like:
> Dim sRegKey As String
> Dim newKey As RegistryKey
> sRegKey = "Software\Microsoft\Office\Word\Addins\MyAddIN"
> newKey = Registry.CurrentUser.CreateSubKey(sRegKey)
> newKey.SetValue("Description", "let me be a working addin",
> RegistryValueKind.String)
> newKey.SetValue("FriendlyName", "MyAddIN", RegistryValueKind.String)
> newKey.SetValue("LoadBehavior", 3, RegistryValueKind.DWord)
> newKey.Close()
>
>
>
> greets
> mitch
>
>
Re: Problem with a Shimmed excel add-in - Help help help [message #696] Tue, 25 July 2006 09:14 Go to previous message
Guilherme - Brazil
Messages: 4
Registered: July 2006
Junior Member
When I run the excel with the addin without shim, the addin is working, but
there ins´t any entry on the "Excel addin Screen"
http://www.cin.ufpe.br/~gbs2/shim/addinscreen.JPG

"Guilherme - Brazil" wrote:

> Hi Michael,
>
> There are these references in the setup project without the shim.
> http://www.cin.ufpe.br/~gbs2/shim/registrySetupProject.JPG
>
> Should I create another setup project with the generated shim DLL(after the
> build on the shim project) and these references in the registry?
>
> Do you have any working shim example ou screen capture of a shim Setup
> project??
>
> Thanks again for the help
>
> Guilherme
>
>
> "Michael" wrote:
>
> > Hi Guilherme,
> >
> > does the Add-In exist in the "COM Add-Ins" window in Excel? and is it
> > checked?
> >
> > if not, setup is missing some registry entrys..
> >
> > something like:
> > Dim sRegKey As String
> > Dim newKey As RegistryKey
> > sRegKey = "Software\Microsoft\Office\Word\Addins\MyAddIN"
> > newKey = Registry.CurrentUser.CreateSubKey(sRegKey)
> > newKey.SetValue("Description", "let me be a working addin",
> > RegistryValueKind.String)
> > newKey.SetValue("FriendlyName", "MyAddIN", RegistryValueKind.String)
> > newKey.SetValue("LoadBehavior", 3, RegistryValueKind.DWord)
> > newKey.Close()
> >
> >
> >
> > greets
> > mitch
> >
> >
Previous Topic:invalid Plugin
Next Topic:Disable shortcut for Print option in Powerpoint
Goto Forum: