Hello everybody.
Here's my question. Is it necessary to register a dll to use it? The way I Know to register a dll is to go to Start, Run and register it manually. Is there any way to register a dll via VBA or via VB?
Thanks!
Hello everybody.
Here's my question. Is it necessary to register a dll to use it? The way I Know to register a dll is to go to Start, Run and register it manually. Is there any way to register a dll via VBA or via VB?
Thanks!
You will need to register an ActiveX DLL, but probably not a standard DLL.
This MS article shows how to register an ActiveX DLL from a client
http://support.microsoft.com/default.aspx?kbid=173407
How To Register Your Custom ActiveX DLL from a Client
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Now I'm busy. I'll have a look later. Thank you. Anyway I think it's the right article so I mark this thread as solved.
There's also a kb entry that installs and registers activex .dll and .ocx files here http://www.vbaexpress.com/kb/getarticle.php?kb_id=447
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
John, that should work for custom dlls and ocx's but may not work for licenced ones.
eg. mscomm32.ocx that comes with VB6 and may show that it is avail in your references (VBA) but would be unavail due to licencing. There is a way around this however.
Kind Regards,
Ivan F Moala From the City of Sails
Sorry. I haven't seen the kb entry. Thanks all of you for the link and the article: That's what I was looking for.