How do I can get Robbin Object from excel.application

frank 1 Reputation point
2020-05-25T14:18:01.537+00:00

Hi all: 

I want to get a menu object(Robbin) from excel that it was developed with VSTO by Ribbon(UI or XML).

I can see the menu(Robbin) on the excel menu, but I can't get it as below:

Excel.Application excel = new Excel.Application("d:\test.xlsx");
foreach (CommandBar bar in excel.CommandBas)
{
...
}

Develop Info:
Excel version: 2016

using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Tools;

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,958 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Li-MSFT 1,096 Reputation points
    2020-05-26T07:38:13.65+00:00

    Welcome to our Microsoft Q&A platform!

    Your problem is more related to VSTO , and it is out of our scope. You could go Visual Studio Tools for Office(VSTO) where you may be assisted better to ask your question.

    Thanks.

  2. frank 1 Reputation point
    2020-05-27T06:00:30.097+00:00

    I don't get it by the vsto project.

    I want get the controls taht was developed with vsto by others and intalled into excel with addin from excel in any project.

    0 comments
  3. Dave Patrick 426.1K Reputation points MVP
    2020-05-28T12:10:38.273+00:00

    Excel is not supported here on QnA. I'd try asking for help in dedicated forums here.

    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev
    home

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments