Kathy,
VBA doesn't (and indeed can't) use either until you set a reference.

Tools References then select either ADO or DAO (or both if you really need
to)

Once you've done that, Intellisense will help you.

NickHK

"Kathy" wrote in message
nk.net...
| Does Excel VBA use ADO or DAO? If both, which is the default? If both, can
you
| specify which to use and where do you set it?
|
| Kathy
|
|