Wilson Associates

Hidden under the covers with all Microsoft Office products is a powerful programming environment. This allows the automation of Word, Excel and Powerpoint documents. In particular data can be retrieved from any source and used in complex ways in documents, letters, reports etc. There is the potential for huge amount to time to be saved with this type of automation. It is surprising how often businesses manually enter data back into reports, letters and other documents when it can be retrieved from a database, entered and formatted using macros.

Word templates can be written that prompt the user for information necessary to retrieve data from a database, and then query the database to retrieve the data. Data can be arranged in tables. It can be used to select optional text depending on the contents of database fields. In fact any layout and text changes that can be manually typed can also be automated.

Similarly Excel workbooks can be automated to retrieve data from databases, and then perform operations such as graphing the data. Excel graphs can be incorporated into Word documents using one automated procedure.

I have extensive experience automating the retrieval of data from different databases including Oracle, Sql Server and Access, and using this data in tables, graphs and other ways in documents.

If you think I can be of service, don't hesitate to call or email at support@wilsonasc.co.nz. I can provide references.