VS2012: Unable to run AddIn for Excel 2010

Question

Hi folks -

I am unable to run a simple AddIn for Excel 2010 created from the Excel 2010 AddIn template. I create a new project selecting the Excel 2010 AddIn template and without adding any code I run the debugger and get the following result in the debug output window:

'excel.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

The program '[5332] excel.exe: Managed (v4.0.30319)' has exited with code -2146233082 (0x80131506).

Please let me know what additional information you need to aid in getting this problem resolved.

- Wayne

Answer 1

i;m not sure if i can spot here any error. Can you run excel 'by hand' and see if you have your add-in listed in add-ins window?

Answer 2

Hi Wayne,

Thank you for posting in the MSDN Forum.

I've find out a blog on Debugging Assembly Loading Failures, it mentioned several scenarios and solution against them.

You can take a look on that. If there's still any problems, please feel free to let me know.

Best regards,

---

Quist Zhang [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

When Excel is opened manually immediately after attempting to run in the debugger a message box appears stating that there was a problem would you like to disable the addIn. When No is selected, Excel opens and the addIn is active.

I also tried this with a simple ribbon and even though the debugger aborted, the ribbon was available when Excel was opened manually.

Here is the message that I have seen before with VS 2008 when I intentionally stop the debugger. For reasons yet unknown to man the debugger in VS 2012 seems to be aborting after building the addIn even though the addIn does not seem to have any issues.

Answer 4

so problem is with vs2012 trying to debug add-in project for excel 2010. is this project an upgrade from solution from previous versions of VS? do you have other VS versions installed on that computer?

Answer 5

The project is right from the Excel 2010 AddIn project template. This machine also has VS2008 installed, VS2010 Trial that is expired and SQL Server 2012 which utilizes VS2010 shell. It is a 64-bit machine with a 32-bit version of Excel 2010 installed.

I originally ran into the problem when upgrading what was originally an Excel 2007 AddIn solution from another machine.

Answer 6

ok, 2 things:

1 for add-in startup event

2 can ypu tell us order of installtion of all visual studios and sql management studio?

Answer 7

Nothing has been added to the StartUp event.

Order of installation of products

VS2010 Trial, VS2008, SSMS2012, VS2012

This is a new machine so there is little lost by uninstalling these items.

Answer 8

please make new excel add-in projct from template, change nothing, just hit f5 - does it work or end the same? if latter, pleae run repair on vs 2012

Answer 9

I tried repairing at first an posted the error message here:http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/e3966fa7-f5d4-486d-bffd-64ce75f8701b where I was asked to post my problem elsewhere.

I am now in the process of removing all versions of VS and SQL Server from my machine and plan to reinstall VS2012 and MSSQL2012 afterwards. This machine hasn't generated anything of value yet so beginning again isn't a problem. It is more than likely that I expected too much installing various versions of VS and SQL Developver Edition and most likely installed something out of order.

Thank's for your assistance  

Answer 10

small hint - install mssql 2012 first since it installs vs2010 shell, which has annoying side effect to be the first option to open VS related files.