VSTO - Visual C# training course (3 days)
Visual Studio Tools for Office (abbreviated to VSTO, and affectionately known as VSTO) is the application Microsoft want you to use to program within Microsoft Office. If you want to see what the future holds for VBA, find out on this three-day course! This course uses C# as a programming language.
VSTO - Visual C# training - Course Contents
The contents of our VSTO - Visual C# 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, and also some coding in some variant of C. 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.
