permanently add library reference

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

Create a template with that reference.

--

HTH

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


"Loane Sharp" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> Create a template with that reference.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Loane Sharp" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > Create a template with that reference.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Loane Sharp" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >>
> >>
> >>
> >
> >
>

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

RBS

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > Create a template with that reference.
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "Loane Sharp" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> 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
>> >>
>> >>
>> >>
>> >
>> >
>>
>
>