debugging a VB6 dll used in excel

[lalbatros]

I would enjoy learning how I could debug a VB6 dll launched from the XL environment.

In order to manage a number crunching functionality in an easier way as well as to reduce file size I decided to remote the VBA code to a VB6 dll. This work fine, and I am very happy with it.

But there is now a disadvantage: I don't know how to debug in this situation and I must maintian two versions, one for development fully within xl and the other combining XL and VB6. This implies frequently moving code and it is not confortable.

In the past, I was used to debug J++ dlls launched from XL.
But I don't see how this could be done with VB6.

Any idea?

Thanks

 

[AlexM]

Try to use VB | Project | <project name> - Properties | Debugging tab.
Select appropriate settings on this tab.

 

[xld]

In VB6, start the DLL.

Then in VBA, go into debug, step into the DLL call, and it should take you seamlessly into the DLL.

 

[Legacy 98055]

Here is the only way I know of. From Excel, remove all references to the DLL. Close the references dialog and save the workbook.

Now run your DLL from within Visual Studio. From Excel, VBAIDE, Tools, References, Browse, set a reference to the "currently running" vbp file. NOT the dll file. You cannot debug a dll file on the run in VB.

 

[lalbatros]

Thanks a lot, all of you.

In the end it work very much like my familiar J++ - VS environment.
I just had re-organize myself a little bit with the references.

Thanks