I have a client who wants to code some excel vba and have me develop an autocad drawing.
I'm using a c#.net dll exposed to com.
He wants to pass an ADODB.Recordset to me for processing the requirements for the drawing.
I referenced the com ADODB type library inside my app so I could work with the recordset object.
I wasn't able to pass it from the vba app directly as I kept getting a type mismatch error.
So, I changed the method to accept an object and used casting to extract the recrodset from the object.
In the vba app I simply passed the recordset as a variant.
This works but I gotta believe there is a better way.
Any ideas?