VSTO - Visual Basic training course (3 days)
Microsoft would much rather that everyone stopped writing code within Excel, Word and Outlook using VBA, and switched to using Visto (VSTO, or to give it its full name, Microsoft Visual Tools for Office) instead. This three-day course allows you to do just that!
VSTO - Visual Basic training - Course Contents
The contents of our VSTO - Visual Basic course are as follows (any items marked with a * will be covered if time allows):
Overview of VSTO
- What is VSTO?
- Pros and cons versus VBA
The types of project
- Standalone Windows forms apps
- Application level add-ins
- Document projects
VSTO Basics
- Creating a project
- Solution Explorer
- Primary Interop Assemblies
Basic coding
- Writing comments
- Message boxes
- Using variables
- Code regions
Debugging and error handling
- Basic debugging
- The TRY statement
Document level projects
- Adding VSTO controls
- VSTO toolbar alignment
- Reacting to control events
- Example - DateTimePicker
Excel workbook projects
- NamedRange controls
- ListObject controls
- Reacting to events
Application level add-ins
- COM versus VSTO add-ins
- Using ThisAddIn
- Add-in events
Windows Forms applications
- Getting forms to pop up
- Drawing basic forms
- Modal versus modeless forms
|
Basic data programming
- Creating connections
- Data bound controls
- Data sets, sources and adapters
- ListObject data events
Task Panes
- Document action task pane
- Adding controls
- Custom user controls
- Application level custom task panes
Ribbon customisation
- Limitations
- Types of ribbon control
- The ribbon designer
- Custom tabs
SmartTags
- Configuring SmartTags
- Creating your own SmartTag
- Attaching events
- Stopping the Recognizer
User-defined functions
- Programming UDFs
- Automation add-ins
- Registering
ClickOnce deployment
- Prerequisites
- Setting a publish location
- Publishing
- Updating
- Overview of security
|
You will find the course easier if you have already done some programming in VBA, however basic. The course does not assume any knowledge of Visual Studio, although clearly this helps. There will be a maximum of 6 people on each course, and each person will have their own computer.
