Programatically load reference ActiveX Data Objects x.x Library 1

[osx99]

I have some code which requires reference to the
Microsoft ActiveX Data Objects x.x Library; The one I am using is the'Microsoft ActiveX Data Objects 2.8 Library'

Eventually this code may be used by other people. Is there a way to programatically load the required reference in VBA?

Thanks,
Os

 

[HarleyQuinn]

Which application?

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com

 

[HarleyQuinn]

As a general thought on this you should be able to use:

Application.VBE.ActiveVBProject.References.AddFrom...

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com

 

[osx99]

It's in Excel

Can you give me a little bit more help with this one on syntax and where to place

This is the location of the reference I need
C:\Program Files\Common Files\System\ado\msado15.dll

Application.VBE.ActiveVBProject.References.AddFrom ("C:\Program Files\Common Files\System\ado\msado15.dll") doesn't work for me

Should this go in a Workbook_Open Event or is it ok to put in a module?

Thanks,
Os

 

[HarleyQuinn]

Sorry, the AddFrom... was to indicate there are two choices for the AddFrom (being AddFromFile and AddFromGUID, AddFromFile is what you're after). Try:

Application.VBE.ActiveVBProject.References.AddFromFile "C:\Program Files\Common Files\System\ado\msado15.dll"

I'd probably put in a module and call it seperately but it will work either way.

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com