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
Printable View
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
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