Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    15

    Question Unanswered: How to Open Excel Templat From Visual Basic

    Hi

    I want to Open an excel templat from Visual Basic Programme. How do i Do that


    Thank you

    Regards
    Gandhi

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Gandhi -

    You use the same methods as you would for a database, except that you: (1) must add the excel object library" to the project references, (2) need to add extended properties for excel to your ADO connection string, and (3) use the worksheet name and data range, instead of the table name, in your SQL statements. I suggest you check out the MS knowledgebase.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •