PDA

View Full Version : How to Open Excel Templat From Visual Basic


dgchoudary
07-03-02, 03:26
Hi

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


Thank you

Regards
Gandhi

vududoc
07-03-02, 09:15
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.