VB and MS Excel through code only

[kiosk77]

There's an excellent tutorial here to work with MS Access through code only (no data control) ... how do I do the same with a MS Excel spread sheet...any help is greatly appretiated. Thank you all in advance

[Edneeis]

Look up information on Subclassing. Or just add a reference in your project to the Excel object and check out the events and use the help files from Excel.

Reference the Microsoft Excel 9.0 Object

declare it something like

Public appExcel As Excel.Application

appExcel.Workbooks.Open "c:\MySpreadsheet.xls"

then you can pretty much figure out what stuff does by the name or just search the VBA help files from Excel