auto include reference(s) 2

[link9]

hello all --

Quickie for yas --

Is there a way (a line of code) that will automatically include a reference library for a vba application????

Here's the deal -- I have a vba module that has to run on an excel file -- The excel file is derived from an exported .csv and the module is imported to each new file --

I'd like to be able to add a line of code to the top of the module that would automatically reference the ADO library without me having to go to tools-->references and then selecting it from the list --

any input appreciated.
Paul Prewett

 

[jonscott8]

XL2000: How to Programmatically Create a Reference

http://support.microsoft.com/support/kb/articles/Q213/5/29.ASP

You can also alternatively use late-binding, alleviating the need for the reference:

SET oConnection = CreateObject("ADODB.Connection&quot
SET oRS = CreateObject("ADODB.Recordset&quot Jon Hawkins

 

[link9]

excellent --

thank you.