The overall aim of the course is to give the delegate an in-depth knowledge of how to use OLE Automation to interact with the major Microsoft Office Components top

Objectives:

At the end of the course the delegate will be able to complete the following list of functions:

What is OLE Automation

Understand the concept of OLE Automation
Understand the similarities and differences between OLE automation and DDE
Know which products expose Automation objects top

The Windows Registry

Understand the basic structure of the registry
Use the registry editor to search the registry
Use the Registry editor to browse and alter registry entries
Use Windows DLL calls to create and query registry entries

Object Variables

Create object variables that reference various OLE Automation servers
Understand the use of an object variableVBA - Visual Basic for Applications
Understand the place of VBA as a macro language in the Microsoft Office Suite
Understand basic VBA syntax & concepts top

Microsoft Excel

Understand the Excel object model
Use the Excel help file as a reference for Excel objects
Use the Excel help file as a reference for VBA functions
Connect to Excel as an OLE Automation server
Record a Macro in Excel to act as a model for OLE Automation code
Use OLE Automation to manage Excel Workbooks
Use OLE Automation to manage Excel Worksheets
Understand the Range object, used to access data in Excel
Format & Print Excel worksheets using OLE Automation top

Microsoft Word

Understand the use of Word Basic
Know the essential differences between Word Basic and VBA
Use the Basic object to connect to Word as an OLE Automation server
Use OLE Automation to manage Word documents - Opening / creating / saving
Use bookmarks in Word
Use the text formatting features of word via OLE Automation
Print a Word document VIA OLE Automation top

Microsoft Graph

Understand the Graph object model
Create Graph objects with your own data
Know how to specify the type of graph required
Use OLE Automation to adjust various graph format parameters
Print a Graph

Other OLE Automation Servers

Briefly discus other servers. Such as MS PowerPoint, MS Project, MS Schedule +, MS Office Binder, The forthcoming MS Exchange server. top

Particulars:

Cost: £620 ( € 992) excluding VAT
Platform: Microsoft Windows 95/3.11
Numbers: Maximum of 6 people on each course at F1’s training facilities in London. top