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
- 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
Â
Copyright © 2012 Colombus.com - All rights reserved
Tel : +41 21 661 1675 - Fax : +41 21 661 1673 - Email : [email protected]