Connecting Excel with VB

[shumaila]

Hi,
Does any one know how could i connect MS Excel with VB through ODBC?

[ecannizzo]

There are a couple of ways to do this. You can use the OLE on the toolbox, which embeds the Excel document in the Application. Or you can reference Excel in Project -- References and open it using code (it will open in a separate window).

HTH,
Erica