I wrote a very simple ActiveX DLL (in VB6) with a function in
"globalmultiuse" class module.

I can call the function in a module in Excel if I make a manua
"reference" to it in the VBA References dialog window.

1. Is there a way to either call the function directly using th
declare - lib approach?

2. Or can I set the "references" up programatically in a module i
Excel (instead of thru the VBA references editor dialog)?

My intention is to create a set of routines for my company that I ca
distribute to customers (but I don't want the working code to b
visible as in an Excel module). I also want to make it as painless o
the user as possible which is the reason for my questions above...

Thanks for any help,
Ric

--
Message posted from http://www.ExcelForum.com