Excel VBA Referencing

2 posts / 0 new
Log in or register to post comments
Last post
Mon, 02/05/2018 - 16:42
#1
scotchy33
Offline
Joined: 09/05/2012 - 15:51
Excel VBA Referencing

Can IDEA script reference DLL's and tlb's similar to what you do in Excel VBA.  If so, how?
I would like to reference Microsoft ActiveX Data Objects 2.8 Library.
See attached screenshot.

Images: 
Top
Tue, 02/06/2018 - 07:11
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Scott,

If you can access it, it would be through the CreateObject function. 

I did a google search and found this page that might help you get going: https://docs.microsoft.com/en-us/sql/ado/guide/appendixes/using-ado-with...

So I guess it would be:

Dim conn1 as object
Set conn1 = CreateObject("ADODB.Connection")

Hopefully this will get you started.

Brian

Top