question

frank-0120 avatar image
0 Votes"
frank-0120 asked DSPatrick answered

How do I can get Robbin Object from excel.application

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexLi-MSFT avatar image
0 Votes"
AlexLi-MSFT answered frank-0120 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I want to know Microsoft.Office.Interop.Excel or other office dll has any PAI which can access to the control in the Ribbon Tab it was developed by others.

0 Votes 0 ·
frank-0120 avatar image
0 Votes"
frank-0120 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.