Excel Automation Add‐ins
Daniel J. Duffy, Andrea Germani · 2013
This chapter discusses how to manipulate the objects in the Excel application object model. This is called automation and it is a generic term that allows a host application (or automation client) to access the objects in a target application (or automation server). All the Office applications can be used as automation servers and the chapter concentrates on Excel. It gives a global overview of the design principles underlying automation. The chapter introduces and defines the number of concepts before it actually creates an Automation add-in. It describes the steps at a high level and then presents a number of examples. The chapter concludes by discussing how to call automation add-in functions from VBA.