Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|