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
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