Office Automation

​Microsoft Office supports interfaces and tools to allow direct integration with backend systems, web services, and workflows.  These integration tools can be used to automate perpetual  tasks or simply streamline the creation of new documents.

​Office automation has been existence for many years, but often in the form of VBA scripts or Macros.  This type of development required a very specialized set of skills and was typically difficult to support.

Today Office 2007 and 2010 support a robust set of interfaces that can be created with any standard Visual Studio .NET toolkit.  Combine this with Windows Workflow Services and document content types in SharePoint, and you have a powerful automation tool for custom document generation, review, and publishing.