Pat,

This question was asked a couple of days ago.

You should be able to debug the VB6 DLL while calling its methods from
within VBA.

To do this, open the project in VB6, and step into it, and step through all
tyhe in itialisation code until it is fully initialised.

Then go to your VBA project, and step into that. Calls into the DLL will
then step into that project.

With this, you can set breakpoints, use the watch and immediate windows as
with any VB/VBA project.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"PM" wrote in message
...
Hi !

My VBA code calls a VB6 dll.

At present, not knowing otherwise, I compile my dll in vb6 (using exit
subs
in place of stop points), then open Excel and my workbook, try the dll and
so forth. This is painstakingly long.

There must be a better way, trying out the dll in VB without compiling it.
Anyone know how to ?
(I guess this is really a VB question...)

Thanks.
Pat