left-banner

Object Automation:


The PC has provided individual users with extraordinary access to information. Many if not most use modern offices packages like Microsoft Office® with its combined spreadsheet, word processing and database capabilities.

Unfortunately most people resort to cut and paste to move data between office packages.

But, there is a hidden power within office to automate functionality between these packages.

WATCH DATA FROM ACCESS AUTOMATICALLY FILLING AN EXCEL TABLE

Elements in a Database Row

|ID|,|First_Name||Last_Name||Address||City||State||Zip|
7Joe Smith anywhere ny ny""

WORD Document Source Template

Office Automation used to place Access database fields in the word document


This is a lot easier than typing the values or even using cut and paste.

As long as the program generated "report" is consistent over time the "cost of programming" will outweigh the costs of "manual updating." Office has a built-in language called Visual Basic for Applications®. It also has an Application Program Interface routines (API) that enble programs to automated actions between and within the various applications in the suite.

PROGRAMS WITHOUT AN API CAN ALSO BE AUTOMATED

Automation programming is a speciality of ours.