how to debug COM dll

1. Run Excel application.
2. Open your COM project in VS
3. In VS, Click on "Debug-> Processes" menu item
4. From the "Available processes" list, select the Excel process you just started and click attach.

Now you can set the break point in your COM project and do something that will invoke your COM object. See whether it works :)

Hi, poochi,

It seems not working.

I use

Application.Run("comFunction")

to call function in an assembly.

It never returns and it never goes to the breakpoint in COM.

Do you have any idea what is going on?

Thanks.

CR

Hi, poochi,

Here is how I did:

(1) In C# project, I build and register the COM.

It has a function like
public void test()
{
}

(2) In VBA, I add the registered COM to the reference list.
Using Object Brower, I can see the COM exports a function named test and it takes no arugment and returns nothing.

(3) In VBA code, I call the function

Application.Run("test")

Whenever the program exectues this line, it quits itself. Something must be wrong there, but I don't know.

Thanks,

CR