What's the deal with Microsoft's and books' syntax?

[Mitch]

I'm trying to access an excel spreadsheet from within VB with an ADO. I can
get it to work if I open Excel in the background without the ADO and pull
the info from there. However, this solution is very slow. I've reasearched
Microsoft's website and my "Visual Basic 6.0 Black Book", but the syntax
in these places doesn't seem to work. VB6 gives syntax errors when I try
to use the .open method, "provider = ...", etc.... Can someone tell me why
no one's by-the-book syntax works for me?

Thanks a million times!

[Paul Clement]

On 11 Nov 2002 11:45:09 -0700, "Mitch" <mtrackers@yahoo.com> wrote:

¤
¤ I'm trying to access an excel spreadsheet from within VB with an ADO. I can
¤ get it to work if I open Excel in the background without the ADO and pull
¤ the info from there. However, this solution is very slow. I've reasearched
¤ Microsoft's website and my "Visual Basic 6.0 Black Book", but the syntax
¤ in these places doesn't seem to work. VB6 gives syntax errors when I try
¤ to use the .open method, "provider = ...", etc.... Can someone tell me why
¤ no one's by-the-book syntax works for me?
¤
¤ Thanks a million times!

See if the following helps:

HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default...;en-us;q257819


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)