I am trying to create a simple ribbon add-in using VS 2010 and Excel 2007 using VSTO. I tried both Excel Worksheet and Excel with the same results when starting Excel (see below).
I have a larger prototype that I'm trying to build, but so far I canβt get close to setting up the Excel ribbon. Has anyone been lucky to create a simple prototype using VS 2010 and Excel 2007? Are you having problems with access denied while trying to load the add-in file into the DLL? Let me emphasize that there is nothing interesting here ... just 2 buttons that do not even do anything at this moment (excel does not even load the DLL, so there are no breakpoints, etc.).
I tried to use the "caspol.exe" tool to fully trust my DLL, this did not change anything. I made sure that the folder in which the dll is built has the privileges "All". I tried to publish and install the add-in, I also tried to just launch it directly from the debugger in VS 2010, the same release again and again. I am an administrator on the server.
Thanks. Jim
Failed to load file or assembly "MyRibbonAddIn, Version = 1.0.0.0, Culture = neutral, PublicKeyToken = null" or one of its dependencies. Access is denied.
***** Exceptional text ******* System.IO.FileLoadException: Failed to load file or assembly "MyRibbonAddIn, Version = 1.0.0.0, Culture = neutral, PublicKeyToken = null" or one of its dependencies. Access denied. File name: 'MyRibbonAddIn, Version = 1.0.0.0, Culture = neutral, PublicKeyToken = null' ---> System.IO.FileLoadException: Failed to load file or assembly 'MyRibbonAddIn, Version = 1.0.0.0, Culture = neutral' or one of his addictions. Access denied. File name: 'MyRibbonAddIn, Version = 1.0.0.0, Culture = neutral'
source share