Late Binding ADODB.Connection and using OpenSchema

[bradja]

Hi All,

I cannot find a solution for this.

How can I use late binding to create an ADODB.Connection object and use cn.OpenSchema as OpenSchema does not work unless I use Early Binding and reference ActiveX Data Objects (which is not possible to reference this in my environment due to restrictions).

Please Login or Register  to view this content.

When I try to run this it debugs on Cn.OpenSchema because it doesn't know what OpenSchema is since the connection object was late binded.
When I change this and use early binding it all works.

[Norie]

What are you connecting to?

[xlnitwit]

Hi,

Did you actually declare the adSchemaTables as mentioned in the code? If you didn't, you must add this line

Please Login or Register  to view this content.

below your declaration lines.

[bradja]

What are you connecting to?

Hi Norie. I am connecting to an .accdb file

[bradja]

Hi,

Did you actually declare the adSchemaTables as mentioned in the code? If you didn't, you must add this line

Please Login or Register  to view this content.

below your declaration lines.

Hi xlnitwit. I did some further playing yesterday (at work) and declared adSchemaTables as you mentioned.
It started working but then I realized I still had the references to ActiveX Data Objects so I removed those, and tried again and it was still working.

I will try again on Monday to see if the late binding is working and will report back here the results.

[ImranBhatti]

Hi,

Did you actually declare the adSchemaTables as mentioned in the code? If you didn't, you must add this line

Please Login or Register  to view this content.

below your declaration lines.

Someone else's post. But the solution given by xlnitwit helped me a lot. I was struggling for the last two days with a Rob Bovey's code to get list of sheets from a closed file.