excel in vb

[Luis Pedro]

Hi.
How to open and use one MS Excel file that have several sheet's ?
Supose that i have on EXCEL file with:
Sheet1: Customers table: COD in Col#1 and NAME in Col#2
Sheet2: Products table: PART in Col#2 and DESCRIPTION in Col#2
I want to write in Sheet3 the header of several orders and in Sheet4 the
detail of the orders in Sheet3.

Who can i do that: Read and Write in MS Excel files with several sheets ?

Thanks

[Val Mazur]

Hi,

You could open Excel file as a database using OLEDB JET 4.0 provider. in
that case each spreadsheet in that Excel file will be like a table. You
could use SQL statements to manipulate your data in that case. See next KB
about how to work with Excel file using ADO

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257819

--
Val Mazur
Microsoft MVP

"Luis Pedro" <lu...@iol.pt> wrote in message
news:agfrdl$c6n$1...@venus.telepac.pt...