ado vba help

[Loane Sharp]

Hi there

I have added a reference to Microsoft ActiveX Data Objects 2.8 Library in my
VBA project. When I search for help topics on a particular subject, I end up
with vast numbers of DAO topics that I don't want.

Do you know how I can remove these references?

Best regards
Loane

 

[Guest]

It seems that when Excel loads its help files it includes the DAO help files
as part of the help "package." Even when I have added the ADO reference and
try to access Help through the object browser (with F1 key) it often seems to
go to the same-named DAO subject instead of ADO, and like you I have been
frustrated by this. Don't know how to rectify this unless, perhaps, you were
to rename the DAO help file so it wouldn't be recognized/loaded. My
solution, often, is to go to the ADO section of the MSDN library and look
things up there instead of through the Excel/VBA help.

 

[Loane Sharp]

Thanks K, I just found it easier to toggle between the VBE and offline help,
but I'd better stick to MSDN Library.

 

[Jamie Collins]

I have added a reference to Microsoft ActiveX Data Objects 2.8 Library in my
VBA project. When I search for help topics on a particular subject, I end up
with vast numbers of DAO topics that I don't want.

If you have other versions of MDAC installed, try referencing another
version. For example, in order to get context ADO help MS Office, I
find I have to reference ADO 2.1.

Jamie.

--