Appendix A. Excel Object Model

For most of the programming tasks that you will do while integrating Excel and Access, Access VBA will automate Microsoft Excel. This makes understanding the Excel object model very important. I have broken down the key parts of the Excel object model that have been most useful to me in automation projects. This is not an all-inclusive list of properties and methods, but understanding this core will make the work much easier. See the Excel VBA help file to get more information on all the properties and methods.