automatically select object references

Is there a way via vba to select references like ms forms or ado or dao,
without having to go through the vba editor? We are distributing sheets
that require references but the people we're sending to won't know how to do
this.

Cheers,

Job

For MSforms, your worksheet will already contain the reference.

For ADO or DAO you could design your code to use late Binding

Nevertheless:

http://support.microsoft.com/default...b;en-us;160647
XL97: How to Programmatically Create a Reference

--
Regards,
Tom Ogilvy


"Job" <[email protected]> wrote in message
news:[email protected]...
> Is there a way via vba to select references like ms forms or ado or dao,
> without having to go through the vba editor? We are distributing sheets
> that require references but the people we're sending to won't know how to
do
> this.
>
> Cheers,
>
> Job
>
>

"Job" <[email protected]> wrote in message
news:[email protected]...
: Is there a way via vba to select references like ms forms or ado or dao,
: without having to go through the vba editor? We are distributing sheets
: that require references but the people we're sending to won't know how to
do
: this.
:
: Cheers,
:
: Job
:
:

Have you looked into late binding?
Paul D

Ok good. Never realized that is what I was doing. Thanks for the late
Binding info!


"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> For MSforms, your worksheet will already contain the reference.
>
> For ADO or DAO you could design your code to use late Binding
>
> Nevertheless:
>
> http://support.microsoft.com/default...b;en-us;160647
> XL97: How to Programmatically Create a Reference
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Job" <[email protected]> wrote in message
> news:[email protected]...
>> Is there a way via vba to select references like ms forms or ado or dao,
>> without having to go through the vba editor? We are distributing sheets
>> that require references but the people we're sending to won't know how to
> do
>> this.
>>
>> Cheers,
>>
>> Job
>>
>>
>
>