View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Where is ADO Data Control???

Adding a reference gives you access to the Type Library for early binding,
essentially using ADO in code with no visible control.
If you want the control, right-click on the Controls Toolbox, select
Additional Controls and put a check mark against the desired component.

Having said that, I have always preferred the coded version to the data
control for flexibility.

NickHK

"Chinx21" . wrote in message
...
Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE using
TOOLSREFERENCES but I still cannot find the ado data control in the
toolbox..By the way I'm using Excel 2002. I hope you'll help me..