HELP: Debugging VB.NET Excel Add-In

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • fjlaga

    #1

    HELP: Debugging VB.NET Excel Add-In

    I wrote an Excel Add-In in VB.NET using Visual Studio .NET 2003 and the
    ..NET Framework version 1.1.4322 on my previous machine. This machine
    had MS Office 10 installed on it. With this configuration I was able
    to run Excel from the debugger, my add-in loads on startup in Excel,
    and I could debug my add in.

    I got a new machine. This machine has both .NET 1.14322 and .NET 2.0
    installed on it and it has MS Office 11 installed. It also has VS.NET
    2003. I copied over the add-in project and rebuilt it. Then I ran my
    installer to install the debug version on the machine (just as I did on
    the previous machine). When I run under the debugger, Excel starts up
    and then exits immediately. If I try again Excel starts and gives this
    error message:

    "Excel experienced a serious error the last time the add-in '<myaddin>'
    was opened. Would you like to disable this add-in? To reactivate this
    add-in, click About Microsoft Office Excel on the Help menu, and then
    click Disabled Items"

    If I disable it, I can launch Excel from the debugger, but (of course)
    my add-in is disabled and does nothing. If I don't disable it, Excel
    continues to exit immediately when launched from the debugger.

    If I launch Excel normally, it starts up fine and my add-in is loaded
    and runs. But, I can' t debug.

    How can I fix it so I can launch Excel from the debugger and debug my
    add-in?

    Any help is greatly appreciated.

Working...