ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ado vba help (https://www.excelbanter.com/excel-programming/325704-ado-vba-help.html)

Loane Sharp

ado vba help
 
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



K Dales[_2_]

ado vba help
 
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" wrote:

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




Loane Sharp

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


"K Dales" wrote in message
...
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" wrote:

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






Jamie Collins

ado vba help
 

Loane Sharp wrote:
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.

--



All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com