COURSE CONTENT
Module 1 - Using Visio VBA
Using VBA
Creating a project
OLE Automation Basics
Overview of the Visio Object Model
Overview of Objects, Properties, Methods and events
When and How to Run your Program
Running VBA code from Visio
Using the Macro Recorder
Module 2 - Working with Shapes
Placing a shape onto the drawing page
Getting information about the shape
Adding text to a shape and changing its attributes
Adding and removing shapes
Performing operations on a shape
Working with formulas and cells from a shape’s shapesheet
Adding and deleting sections and rows from shapesheets
Module 3 - Automating connections
Connecting shapes together
Determining which glue to use
Module 4 - Properties and Formulas
Connecting Shapes
Adding Data to Shapes
Printing and Saving Documents
Quitting Visio
|
Module 5 - Getting Data from Drawings
Types of Visio Data
Module 6 - Iterating through a Collection
Getting Information from Documents, Pages,
Shapes and Shapesheets
Working with Windows and Selected Shapes
Getting Information about Connections
Generating and using Unique Ids
Module 7 - Visio events
Overview of events
Creating events from This Document
ActiveX controls
Adding ActiveX controls
Handling control events
Working with controls at runtime
Module 8 - Links to databases (using Access)
Identifying a database
Creating and Opening recordsets from Visio
Manipulating recordsets from Visio
Transferring data to and from a Visio shape/drawing
|
4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk |