Notes
Outline
COM CALL-OUT
FOR
OFFICE AUTOMATION
(Word & Excel)
Slide 2
WHAT IS COM
Definition of certain terms
C-A high-level programming language developed by Dennis Ritchie at Bell Labs in the mid 1970s
C++-A high-level programming language developed by Bjarne Stroustrup at Bell Labs. C++ adds object-oriented feature to its predecessor,C.
Visual Basic-A programming language and environment developed by Microsoft.. Based on the BASIC language, Visual Basic was one of the first products to provide a graphical programming environment for developing user interfaces.
Definition …- Continued
VTBL-A virtual function table is an array of pointers to the methods an object supports.
DLL-Short for Dynamic Link Library, a library of executable functions or data that can be used by an application
Object-An object is a self-contained entity that consists of both data and procedures to manipulate the data
Hierarchy:A partially-ordered structure of entities in which every entity but one is successor to at least one other entity; and every entity except the basic entities is a predecessor to at least one other entity
Architecture
Slide 7
COM w.r.t Uniface-Dependencies
COM w.r.t Uniface -Limitations
Office Object Model-
Overview &Task Automation
Each unit of Office applications comprise of objects
Hierarchy of Word Objects
Hierarchy of Excel Objects
Using the VB Editor to understand object hierarchy
Examples
COM Call-out from Uniface to Word to
Open and close a word document
Add a paragraph and copy from Uniface edit box and paste to the paragraph
Copy from a paragraph to Uniface edit box
COM Call-out from Uniface to Excel to
Open and close a excel workbook
Pick values from cells in worksheet and multiply them in Uniface
Relationship of Word Objects
Relationship of Excel Objects
Troubleshooting
Check the paths for the office objects to be used
Check if you are using correct interfaces