I have an application coded in an XLA (hide the code from the user) an
have added an extra function (a class object) which I have coded in
vb dll.
This works fine in my environment where I can set the reference to th
dll in the xla but in a production environment where the user can't se
the code, the tools/references menu is not available and the dll can'
be referenced.
Is there a solution other than to lump the dll code into the xla

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

setcurdir en curdrive to location dll and call the dll without a pathname

"rodt" schreef in bericht
...

I have an application coded in an XLA (hide the code from the user) and
have added an extra function (a class object) which I have coded in a
vb dll.
This works fine in my environment where I can set the reference to the
dll in the xla but in a production environment where the user can't see
the code, the tools/references menu is not available and the dll can't
be referenced.
Is there a solution other than to lump the dll code into the xla?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

The problem isn't the inability to reach the Tools/References menu on
the users machine, the problem is that your DLL is not registered on the
users machine. Once the DLL is properly registered on the users machine, the
reference in your .xla will work fine.

If this is a very simple scenario and your users are smart, you could
have them register the DLL manually by opening a command prompt window and
typing:

C:\regsvr32.exe MyDLL.dll

where "MYDLL.dll" is the name of your DLL. If you need this to be done
automatically my best suggestion would be to use the Setup Wizard that comes
with VB to create an installation package from your DLL. This will handle
the registration of the DLL automatically.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"rodt" wrote in message
...

I have an application coded in an XLA (hide the code from the user) and
have added an extra function (a class object) which I have coded in a
vb dll.
This works fine in my environment where I can set the reference to the
dll in the xla but in a production environment where the user can't see
the code, the tools/references menu is not available and the dll can't
be referenced.
Is there a solution other than to lump the dll code into the xla?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/