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)


"Loane Sharp" <look_sharp_not@hotmail.com> wrote in message
news:OzqtUjoAGHA.3268@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>

[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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uD9HA0oAGHA.2984@tk2msftngp13.phx.gbl...
> Create a template with that reference.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Loane Sharp" <look_sharp_not@hotmail.com> wrote in message
> news:OzqtUjoAGHA.3268@TK2MSFTNGP10.phx.gbl...
>> 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]

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" <bartsmissaert@blueyonder.co.uk> wrote in message
news:eJ44skpAGHA.140@TK2MSFTNGP12.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uD9HA0oAGHA.2984@tk2msftngp13.phx.gbl...
> > Create a template with that reference.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Loane Sharp" <look_sharp_not@hotmail.com> wrote in message
> > news:OzqtUjoAGHA.3268@TK2MSFTNGP10.phx.gbl...
> >> 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
> >>
> >>
> >>
> >
> >
>

[RB Smissaert]

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

RBS

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:u9oHAAvAGHA.216@TK2MSFTNGP15.phx.gbl...
> 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" <bartsmissaert@blueyonder.co.uk> wrote in message
> news:eJ44skpAGHA.140@TK2MSFTNGP12.phx.gbl...
>> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
>> news:uD9HA0oAGHA.2984@tk2msftngp13.phx.gbl...
>> > Create a template with that reference.
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "Loane Sharp" <look_sharp_not@hotmail.com> wrote in message
>> > news:OzqtUjoAGHA.3268@TK2MSFTNGP10.phx.gbl...
>> >> 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
>> >>
>> >>
>> >>
>> >
>> >
>>
>
>