XLA calls dll  
Author Message
JosPeters





PostPosted: Mon Nov 17 15:58:01 CST 2003 Top

Excel Programming >> XLA calls dll

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.hide-link.com/
~~View and post usenet messages directly from http://www.hide-link.com/

Excel479  
 
 
Gerrit





PostPosted: Mon Nov 17 15:58:01 CST 2003 Top

Excel Programming >> XLA calls dll setcurdir en curdrive to location dll and call the dll without a pathname



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


 
 
Rob





PostPosted: Mon Nov 17 16:08:16 CST 2003 Top

Excel Programming >> XLA calls dll
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 *




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