Using the VBA programming language to generate and print various protocols in Excel from WinCC
75 000₽
Details:
The course is dedicated to acquiring skills in writing VBA programs to generate and print various protocols in Excel from WinCC. At the same time, the practical part of the course is closely related to the standard database structure of WinCC, providing support for specialists working with this SCADA system.
| Prerequisites |
Basic knowledge of the Microsoft Windows operating system and its main capabilities. Basic knowledge |
|---|---|
| Course duration |
5 days |
Description
The course is dedicated to acquiring skills in writing VBA programs to generate and print various protocols in Excel from WinCC. At the same time, the practical part of the course is closely related to the standard database structure of WinCC, providing support for specialists working with this SCADA system.
Course duration: 5 days.
1. Data types, variables, and constants.
2. Arithmetic operations, logical operators, working with strings.
3. Using functions and subroutines (procedures) in VBA.
4. Branching statements and loops.
5. Objects and collections.
6. Working with arrays in VBA.
7. File management using VBA.
8. Managing VBA host applications.
9. OLE technology.
10. Accessing DLLs from VBA.
11. Using event handlers.
12. Accessing databases from VBA code, ADO technology.
13. Fundamentals of the Transact-SQL language.
14. Working with SQL Server.
Ближайшие даты проведения курса уточняются. Для записи на курс, обратитесь к менеджеру удобным для вас способом связи.
| Prerequisites |
Basic knowledge of the Microsoft Windows operating system and its main capabilities. Basic knowledge |
|---|---|
| Course duration |
5 days |
