Microsoft Excel – Developing Applications II

• 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

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

• Professional explanation with practical samples and examples.

• Powerpoint handouts and module printouts.

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

Previous courses

Programming and Algorithmization Basics [PRG]

Microsoft Excel – Advanced Methods and Functions [MSEX3]

Microsoft Excel – Developing Applications I [MSEX5]

Related courses

Microsoft Access – Application Development [MSAC2a]

Introduction to Microsoft Visual Basic .NET Programming [GOC301]