Course code: MSEX6« Back

Microsoft Excel – Developing Applications II

In this course you get a lot of practical skills that are needed for developing applications for MS Excel. You learn how to access the file system and write their own procedures for Import / Export, you access an SQL database server and familiarize yourself with objects Connection, Command, and Recordset using ADO library, learn how to create custom forms and interact with the controls, you create add-ins for Excel you know many other options. To attend the course is knowledge of VBA and Excel object model level course MSEX5

 DateDurationCourse priceHandbook priceCourse languageLocation 
12/16/2019 4 18 000 CZK included in course price Český jazyk GOPAS Praha
 
2/10/2020 4 18 000 CZK included in course price Český jazyk GOPAS Praha
 
4/27/2020 4 18 000 CZK included in course price Český jazyk GOPAS Praha
 
1/27/2020 4 17 600 CZK included in course price Český jazyk GOPAS Brno
 
4/27/2020 4 17 600 CZK included in course price Český jazyk GOPAS Brno
 
11/26/2019 4 600,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha4 18 000 CZK included in course price 40
Brno4 17 600 CZK included in course price 40
Bratislava4 600,00 EUR included in course price 40

What we teach you:

  • Working with files and folders.
  • Import / export data
  • Access data from the database
  • Create add-ins
  • Create custom forms and use controls
  • We will teach you much more practical and useful techniques that you use in your applications

Required skills:

  • Knowledge of working in Microsoft Excel.
  • Knowledge of VBA.
  • Knowledge of Excel object model to the level of the course MSEX5.

Teaching methods:

  • Professional explanation with practical samples and examples.

Teaching materials:

  • Powerpoint handouts and module printouts.

Course syllabus:

Introduction

  • Brief overview of macro recording
  • Brief overview of VBA
  • A brief overview obejktového Excel model

Dialogs

  • Built dialogues Excel
  • Dialogs for working with files

Working with files and folders

  • Object FileSystemObject
  • Reading and writing from a text file
  • Import / Export from Excel

Reading and writing the Windows Registry

  • Reading and writing the Windows Registry
  • Save and load settings

Object-oriented programming

  • Introduction to Object
  • Use properties, methods and events
  • Create and use custom classes
  • Creating and Using Custom Properties
  • Create and use custom events

Basics of creating custom forms

  • Creating a custom form
  • Lifecycle form
  • Load and close the form
  • Basic usage controls

Adapting the work environment of Excel

  • Creating toolbars and menus
  • Creating a custom Ribon

Creating complementary addin for excel

  • What is an Add-On (Add-In)
  • Add-In Manager
  • Create a custom add-ins
  • Optimization Add-Inu

Communication with data sources

  • Library ADO and OLEDB provider
  • Connection object and connect to SQL Server
  • Command object
  • Recordset object

.Net Framework

  • The architecture of the .NET Framework
  • Visual Basic .Net
  • Visual Studio .Net
  • Excel.Application use of .Net
Tištěné prezentace probírané látky

Price:
included in course price
The prices are without VAT.