Unable to see CommandBar in XLL-Project

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

Unable to see CommandBar in XLL-Project
Unable to see CommandBar in XLL-Project 
Gerd Goldberg




Posts: 8
 Joined: 2007-06-07
Hello!
I tried to make a XLL-Addin for EXCEL with 1 formula (I uncommented then formula "AllSupportedExcelTypes"). This worked fine and I could use the formula in my EXCEL-sheet.
Then I tried to add a COM AddIn-Module with one CommandBar and one Button.
I again registered the project, but the CommandBar is not visible in EXCEL.
If I make a new Addin-Module project, the commandbar is visible in EXCEL.
I use Visual Studio 2005 Standard C# and Add-In Express 3.8.1886 Standard.
Before, I had installed Add-In Express for Visual Studio Express.
I found two hints about a similar problem in this forum, but they didn't work.
Thank you in advance for your assistance!
Gerd
Posted 15 Apr, 2008 12:38:41 Top
Gerd Goldberg




Posts: 8
 Joined: 2007-06-07
Hello,
I found the solution by myself.
In one topic of this forum was written, that it is necessary to add EXCEL to the SupportedApps property. So i looked in the various Property forms to find this property but I didn't find it.
Now I added the codeline

this.SupportedApps = AddinExpress.MSO.ADXOfficeHostApp.ohaExcel;

to the "InitializeComponent()" method of the AddInModule and it works!

Gerd
Posted 16 Apr, 2008 11:30:45 Top