Microsoft Word

Goals


- Discover programming via VBA

- Use Word’s VBA Microsoft objects

Program

Objectives of a macro
Display the Developer tab in the ribbon
Record a macro
Run a macro
Run a macro via shortcuts (in ribbon, button, etc.)
Manage macros

Objectives of the VBA language
Presentation of the VBA
Using the VBA Operating
principle of the VBA

See and modify the code of a macro
Language syntax
Variables
Constants
Operators
Integrating a VBA function in an Access macro

The Application object
The Document
object
The Paragraphs object
The Range object The Characters object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Introducing the form
Integrating form controls in Word
Linking a macro to a form event

Integrate Excel’s VBA objects
Drive an Excel file from Word
Import Excel data into Word

Revisions on Word
Questions / Answers
Passing the PCIE certification

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 2495

Audience

Advanced Word users

Prerequisites

Have followed the course « Word: Initiation + Deepening » or have equivalent knowledge

Reference

BUR1147-F

Sessions

Contact us for more informations about session date