The Microsoft OpenXML files we use on a day-to-day basis are conveniently designed to be accessed and manipulated programmatically. We can jump into any OpenXML file structure in a variety of capacities (usually via specialized programming libraries or APIs) to easily manipulate objects within a document and/or retrieve important contents from its various sections.
The flexibility afforded by Office document formats is, to an even greater extent, facilitated by macros. Using the Visual Basic for Applications (VBA) programming language – a specially designed version of the Visual Basic (VB) language – we can add a myriad of dynamic elements to our Office documents and allow our files to seamlessly connect with other applications in our system.
Read the original article: