Debugging VS2010 and Shared Add-In (MS Access)

Question

I've created the Add-In and when I click on debug MSAccess starts up but I cannot get it to stop on a breakpoint in my VB.Net code.  Are there some instructions on how to setup a Shared Add-In project to debug the .Net code?

Thanks.

---

C.Kowitz

Answer 1

1. You will need the Administrator permission to debug the Shared Add-in, Right click on the Visual Studio and let it runas the Administrator, then open you Add-in solution.

2. Set the debug | Start external program point to the Excel(it seems that yours is the MSACCESS.EXE), and set the Working directory to the Office14\

3. Set breakpoint

4. F5 to debug, it start the Excel and hit the breakpoint, after press F5 it show me the MessageBox.

Note: To avoid the pre test add-ins project affect your test, please delete them form your disk, and then clean the pre test add-ins:

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins 

If the addin, also cannot loaded for you to test, then also check these registry to see if the add-in registered here. 

Since I forget to capture some steps screenshot, so I create some new project with difference names, you will see that there're difference project names, but I think you will understand it.

Best wishes,

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us

Answer 2

Thanks that helped.

---

C.Kowitz

Answer 3

You're welcome!

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us