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