Add-In Tab Disappears from Excel

Add-in Express™ Support Service
That's what is more important than anything else

Add-In Tab Disappears from Excel
 
Kurt Roach




Posts: 4
 Joined: 2011-07-06
I wrote an add-in targeting MS Excel for 'All Users' on a machine. The first time it is installed the 'Add-Ins' ribbon tab appears in Excel. When the add-in is uninstalled or a new version is installed over the old version, the next time Excel is opened the 'Add-Ins' tab is gone. It can be made visible by unchecking the add-in in the 'COM Add-Ins' window, closing the 'COM Add-Ins' window, reopening the 'COM Add-Ins' window and checking the add-in.

Is this is a problem with my add-in or with Excel?

Kurt
Posted 06 Jul, 2011 07:21:18 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Kurt,

I suppose this relates to a problem in your add-in. There's another possibility: Add-in Express has a problem in its code.

To find the real cause, I'd like to look at the code of InitializeComponent of your add-in module. You can copy it here or send it to me by email. Please find the support email address in {Add-in Express installation folder}\readme.txt. And make sure your email contains a link to this topic.

Oh, I assume, you don't create command bar controls on the fly. If this isn't so and you create commandbar controls at run-time, I'd like to look at the code of your add-in module.

And what Excel version are you using?


Andrei Smolin
Add-in Express Team Leader
Posted 06 Jul, 2011 08:51:29 Top
Kurt Roach




Posts: 4
 Joined: 2011-07-06
Hi Andrei,

Thanks for the quick reply. I am using Office 2010, and I'm using Add-in Express 2010 for Microsoft Office and .NET, Professional.

Here is my InitializeComponent function: 

    Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Me.AdxCommandBar1 = New AddinExpress.MSO.ADXCommandBar(Me.components)
        Me.AdxCommandBarButton1 = New AddinExpress.MSO.ADXCommandBarButton(Me.components)
        Me.imageList = New System.Windows.Forms.ImageList(Me.components)
        '
        'AdxCommandBar1
        '
        Me.AdxCommandBar1.CommandBarName = "addressProcessor"
        Me.AdxCommandBar1.CommandBarTag = "07c0a358-8077-405a-9420-5a59f01eb181"
        Me.AdxCommandBar1.Controls.Add(Me.AdxCommandBarButton1)
        Me.AdxCommandBar1.SupportedApps = AddinExpress.MSO.ADXOfficeHostApp.ohaExcel
        Me.AdxCommandBar1.UpdateCounter = 5
        Me.AdxCommandBar1.UseForRibbon = True
        '
        'AdxCommandBarButton1
        '
        Me.AdxCommandBarButton1.Caption = "Address Processor"
        Me.AdxCommandBarButton1.ControlTag = "77678586-5ed6-4c89-a4da-65b6f995fab4"
        Me.AdxCommandBarButton1.Image = 0
        Me.AdxCommandBarButton1.ImageList = Me.imageList
        Me.AdxCommandBarButton1.ImageTransparentColor = System.Drawing.Color.Transparent
        Me.AdxCommandBarButton1.St yle = AddinExpress.MSO.ADXMsoButtonStyle.adxMsoButtonIconAndCaption
        Me.AdxCommandBarButton1.TooltipText = "Checks and corrects addresses"
        Me.AdxCommandBarButton1.UpdateCounter = 1
        '
        'imageList
        '
        Me.imageList.ColorDepth = System.Windows.Forms.ColorDepth.Depth8Bit
        Me.imageList.ImageSize = New System.Drawing.Size(16, 16)
        Me.imageList.TransparentColor = System.Drawing.Color.Transparent
        '
        'AddinModule
        '
        Me.AddinName = "addressProcessor"
        Me.Images = Me.imageList
        Me.RegisterForAllUsers = True
        Me.SupportedApps = AddinExpress.MSO.ADXOfficeHostApp.ohaExcel

    End Sub

Kurt
Posted 06 Jul, 2011 09:52:46 Top
Kurt Roach




Posts: 4
 Joined: 2011-07-06
I should also mention that I have tested this in Office 2007 and Office 2003.

Kurt
Posted 06 Jul, 2011 10:01:36 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Kurt,

Thank you. Do you uninstall the add-in before installing a newer version?


Andrei Smolin
Add-in Express Team Leader
Posted 07 Jul, 2011 03:39:16 Top
Kurt Roach




Posts: 4
 Joined: 2011-07-06
Hi Andrei,

Yes, I uninstall it and this problem occurs when I reinstall it.

Kurt
Posted 07 Jul, 2011 07:30:22 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Can you please check if a new add-in imitating the UI of your real add-in behaves in the the same way?



Andrei Smolin
Add-in Express Team Leader
Posted 07 Jul, 2011 08:18:33 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
If the test add-in reproduces the issue, please send it to the support email address, find it in {Add-in Express installation folder}\readme.txt. And make sure your email contains a link to this topic.

If the test add-in works as expected, please send me the the code of your real add-in with all business logic and sensitive info removed.


Andrei Smolin
Add-in Express Team Leader
Posted 07 Jul, 2011 08:40:19 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hi Kurt,

Thank you for sending me the project and the installer.

I reproduce the issue with your installer. I cannot reproduce the issue with an installer created using the latest Add-in Express version. Please try to install the latest Add-in Express version and re-create the installer.


Andrei Smolin
Add-in Express Team Leader
Posted 08 Jul, 2011 09:54:05 Top