| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do this with VBA
-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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to do this with VBA
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to do this with VBA
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to do this with VBA
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to do this with VBA
Try and place the code in a standard module and invoke it from the
workbook_open event: Private Sub Workbook_open() Macro1 End Sub In a module: Sub Macro1() ThisWorkbook.VBProject.References.AddFromFile "C:\Mydll.dll" End Sub HTH Cordially Pascal "voda" a écrit dans le message de news: ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
