I put this code in Thisworkbook use event Workbook_Open.


"papou" wrote:

Voda
Where did you place the code?

HTH
Cordially
Pascal

"voda" a écrit dans le message de news:
...
Hello!
Thanks for your anwsers.
I use your code but get error:"Run-time error '429'. ActiveX component
can't
create object"
Help me


"papou" wrote:

Hello
ThisWorkbook.VBProject.References.AddFromFile "C:\Mydll.dll"

Depending on your Excel version, you may have to check for Security
options
(Tools, Macro, Security), to trust your code.

HTH
Cordially
Pascal

"voda" a écrit dans le message de news:
...
-I use a file .dll in my program: Alt+F11 - Tools/References/Browse...
find
the path of dll and click OK.
-How to do this with some code in VBA
Thanks