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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

  1. #1
    Mitch Guest

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


    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!

  2. #2
    Paul Clement Guest

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

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center