The Microsoft Office 2000 Automation Help file created by Microsoft Technical Support includes theory and example code you can use to learn how to automate Office. It focuses on Office 2000 but most of the information presentation will apply to other Office versions from 97 onward.