permanently add library reference

[Loane Sharp]

Hi there
I find it a bit irritating that I have to add a reference to the ADO library
every time I create a new workbook and VBA procedure. Is there a way to do
this permanently?
Best regards
Loane

 

[Bob Phillips]

Create a template with that reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RB Smissaert]

Or have an add-in that adds the library to the active workbook in the
workbook open event of the add-in.

RBS

 

[Bob Phillips]

With the template though, you can also add a a lot of fundamental code,
useful routines that can be used in any ADO application.

Bob

 

[RB Smissaert]

I suppose they both have pros and cons, it is just another option.

RBS