|Posted by:||Richard Mogy (rmo…@sbcglobal.net)|
|Date:||Thu, 06 May 2004|
I use both Visual Basic and Visual Basic for Applications. In VB I have a
component (Microsoft ADO Control) that can activate and then dim
dim con1 as ADODB.connection
and then select data from my SQL database.
In VBA, there isn't a "Components" selection, only "References". Yet
through various posting on these sites I have seen VBA (Excel) code that
creates the same dim reference.
How do I get VBA to recognize the Microsoft ADO Control?