none
Excel Error with VSTO design-Time adaptor for excel RRS feed

  • Question

  • Since I installed VSTO 2015 I get an error whenever I open Excel I get an error:

    The call to GetCustomUI() for RibbonID "Microsoft.Excel.Workbook" Failed

    I know that it is raised by the VSTO addin "Visual Studio Tools for Office design-Time adaptor for excel"

    If I disabled it in excel, Visual studio doesn't let me to create an excel document project.

    Thank you in advance.



    • Edited by Kelshaer Monday, November 26, 2018 7:51 AM
    Monday, November 26, 2018 7:50 AM

All replies

  • Hi Kelshaer,

    "If I disabled it in excel, Visual studio doesn't let me to create an excel document project."

    For this point, could you please provide some more information e.g. error code?

    Regards,

    Simon


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.


    Monday, November 26, 2018 12:36 PM
    Moderator
  • Same issue here. It's a Catch-22 situation.

    If the VS Add-In is enabled then Excel produces error dialog 'The call to GetCustomUI() for RibbonID "Microsoft.Excel.Workbook" failed.' multiple times in succession, i.e., sometimes twice, sometimes thrice.

    However, if the "Visual Studio Tools for Office Design-Time Adaptor for Excel" COM Add-In is disabled via Excel's COM Add-ins dialog then Visual Studio (Community 2017) cannot create an Excel Workbook Project and generates an error message dialog about the Add-in being disabled. In contrast, if the Add-in is enabled then Visual Studio still generates an error message stating "Project 'Testname' could not be opened because the Visual Basic 2017 compiler could not be created. An item with the same key has already been added."

    Summary: Add-in Enabled = Excel error and VS error, Add-in Disabled = VS unable to create project.

    Plz advise...

    System Info

    Excel 2016 MSO (16.0.11126.20234) 32-bit

    Visual Studio About:
    Microsoft Visual Studio Community 2017
    Version 15.9.5
    VisualStudio.15.Release/15.9.5+28307.280
    Microsoft .NET Framework
    Version 4.6.01055

    Installed Version: Community

    Visual C++ 2017   00369-60000-00001-AA182
    Microsoft Visual C++ 2017

    Application Insights Tools for Visual Studio Package   8.14.11009.1
    Application Insights Tools for Visual Studio

    ASP.NET and Web Tools 2017   15.9.04012.0
    ASP.NET and Web Tools 2017

    ASP.NET Core Razor Language Services   15.8.31590
    Provides languages services for ASP.NET Core Razor.

    ASP.NET Web Frameworks and Tools 2017   5.2.60913.0
    For additional information, visit https://www.asp.net/

    Azure App Service Tools v3.0.0   15.9.03024.0
    Azure App Service Tools v3.0.0

    C# Tools   2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
    C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

    Common Azure Tools   1.10
    Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

    JavaScript Language Service   2.0
    JavaScript Language Service

    JavaScript Project System   2.0
    JavaScript Project System

    Microsoft Continuous Delivery Tools for Visual Studio   0.4
    Simplifying the configuration of Azure DevOps pipelines from within the Visual Studio IDE.

    Microsoft JVM Debugger   1.0
    Provides support for connecting the Visual Studio debugger to JDWP compatible Java Virtual Machines

    Microsoft Library Manager   1.0
    Install client-side libraries easily to any web project

    Microsoft MI-Based Debugger   1.0
    Provides support for connecting Visual Studio to MI compatible debuggers

    Microsoft Visual C++ Wizards   1.0
    Microsoft Visual C++ Wizards

    Microsoft Visual Studio Tools for Containers   1.1
    Develop, run, validate your ASP.NET Core applications in the target environment. F5 your application directly into a container with debugging, or CTRL + F5 to edit & refresh your app without having to rebuild the container.

    Microsoft Visual Studio VC Package   1.0
    Microsoft Visual Studio VC Package

    NuGet Package Manager   4.6.0
    NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

    Office Developer Tools for Visual Studio 2017 ENU   15.0.28224.00
    Microsoft Office Developer Tools for Visual Studio 2017 ENU

    ProjectServicesPackage Extension   1.0
    ProjectServicesPackage Visual Studio Extension Detailed Info

    ResourcePackage Extension   1.0
    ResourcePackage Visual Studio Extension Detailed Info

    ResourcePackage Extension   1.0
    ResourcePackage Visual Studio Extension Detailed Info

    SQL Server Data Tools   15.1.61901.03220
    Microsoft SQL Server Data Tools

    TypeScript Tools   15.9.20918.2001
    TypeScript Tools for Microsoft Visual Studio

    Visual Basic Tools   2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
    Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

    Visual Studio Code Debug Adapter Host Package   1.0
    Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

    Visual Studio Tools for Apache Cordova   15.123.7408.1
    Visual Studio Tools for Apache Cordova

    Visual Studio Tools for Containers   1.0
    Visual Studio Tools for Containers

    Workflow Manager Tools 1.0   1.0
    This package contains the necessary Visual Studio integration components for Workflow Manager.

    Wednesday, January 23, 2019 12:38 AM