Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 593
Default 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.

--

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"