Thomson Reuters - VBA Basic Training (cours KOB001)

Cours disponible en français ou en anglais - Training available in French or in English

Durée: 4 jours

Objectifs du cours :

The goal of this course is to teach users of Kobra and PowerPlusPro how to use Visual Basic to help them in their everyday work. This 4-days course should provide enough insight into VBA (particularly Excel or PPPro VBA) for the candidates to understand how to handle basic issues where the use of Reuters Desktop products in VBA is involved. Many relevant practical examples will be used. In order to keep the participant's attention, a clever mix between theory and practice will be used (i.e. learn & apply to something relevant immediately).

Examples will also use the latest Reuters Desktop Toolkit technology such as AdfinX, DEX and Kobra VBA.

Compétences acquises :

Les stagiaires découvriront les points suivants :

What is a program : compilation, sources, code, modules, classes, etc
Good and bad habits when programming. What to avoid, impacts on maintainability etc
What is VBA, Excel VBA, VB, COM, ActiveX, ...
How to record Macros
The VBA Editor
What are Properties, Methods, Events
What are Subs and functions
How to use Message box/Input box
What are Variables
How to use Conditional arguments (If…then…else, Select...Case)
How to use Locals, Immediate and Watch windows
How to use Loops (For i...Next i, Do until....Loop)
Where to get Help (online, in the MSDN and on the Web)
How to use the Object Browser
How to debug an application
Understand and use some Excel specific objects
How to use Arrays in VBA and Excel
How to work with external components in VBA
How to reference external libraries
How to create Userforms
How to use Events with external components
Kobra and VBA examples

Examples will include :

AdfinX examples
SSL COM examples

Trapping events on sheet change, on cell change (user functions)

Calculating Analytics in VBA using AdfinX

Connaissances requises :

Avant de commencer ce cours, les stagiaires doivent avoir :

Have a good working knowledge of Windows
Be familiar with PowerPlusPro and Kobra
No previous programming experience is required