COM and Integration
Quick Notes
Introduction
Record a Macro
Overview of Automation
Overview of SmartWare Object Model
COM
Interfaces
PROGIDS and CLSIDS
Object Models
Type Library
Troubleshooting
Tips to Code Improvements
Binding
Code Sample
SmartWare Object Model
Create Object
MS Office Object Models
Office and VB
SmartWare and VB
Control Structures
Types
Functions or Formulas
Declaring Variables
EXCEL Objects
Single or Collections
Opening a WorkBook Object
Properties and Methods
Applying Properties and Methods
Convert macro code to SW Code
WITH Statement
Range Method
Offset Method
Current Region and Range
Cells Method
Looping on a Range of Cells
WORD Objects
Objects
Property
Methods
Application Object
Document Object
Open
Create and Save
Activate
Print and Optional Parameters
Closing
Accessing Objects
Returning an Object
Range Object
Adding Objects
Selection Object
Range Method to Return a Range Object
Range Property to Return a Range Object
Modify a Document
Looping a Range of Paragraphs
Stories
The Selection Object
Working with Selection Object
Property and Methods of Selection Object
Move and Extend the Selection Object
Find and Replace
Table, Column, Row, Cell
Selecting Text
Other Common Objects
Header/Footer
Form Field Objects
Code Optimization
Miscellaneous
EXCEL Events
Working With Events
Event Handlers in VB
Chart Events
Application Events
Class Modules and Events
Worksheet Events
Workbook Events1
Workbook Events 2
WORD Events
Document Events
Application Events
ActiveX Events
Auto Macros
DLLs and Window API s
DLL in VB
Declaring a DLL Routine
DLL Calls in SmartWare
Overview
Handling Parameters and Values
Call, Load, Unload
Call Backs