Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > ADO Data > Passing ADO obj...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 12 Topic 4194 of 4320
Post > Topic >>

Passing ADO objects from VBA to ActiveX dll

by "RB Smissaert" <bartsmissaert@[EMAIL PROTECTED] > Apr 2, 2008 at 11:44 AM

I am running code from Excel VBA and with that run procedures in a VB6 
ActiveX dll.
In this VB6 class I use ADO and to avoid any version problems I have used 
late binding. I don't think there is any serious performance penalty from 
this in my particular case, but I wonder if I would use early binding
if I pass the established, early bound ADO objects from VBA to VB6. This 
would then be ADODB.Connection,
ADODB.Command and ADODB.Recordset.
As the VB6 class has no refererence to ADO these ADO object would have to
be 
passed as Object.
Obviously when I do that I will have no intelli-sense in the VB6 class,
but 
would it still be early binding?
Thanks for any advice.

RBS
 




 12 Posts in Topic:
Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 11:44:26 
Re: Passing ADO objects from VBA to ActiveX dll
"Bob Barrows [MVP]&q  2008-04-02 07:02:46 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 12:12:58 
Re: Passing ADO objects from VBA to ActiveX dll
"Bob Barrows [MVP]&q  2008-04-02 07:33:33 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 12:44:20 
Re: Passing ADO objects from VBA to ActiveX dll
"Ralph" <nt_  2008-04-02 08:32:08 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 15:17:36 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 17:41:11 
Re: Passing ADO objects from VBA to ActiveX dll
"Bob Barrows [MVP]&q  2008-04-02 14:18:38 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 19:28:45 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 19:35:12 
Re: Passing ADO objects from VBA to ActiveX dll
"RB Smissaert"   2008-04-02 19:47:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:45:55 CST 2008.