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

RBS

"Bob Phillips" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Create a template with that reference.

--

HTH

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


"Loane Sharp" wrote in message
...
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