INTRODUCTION TO PROGRAMMING IN VISUAL BASIC FOR APPLICATIONS (VBA)
Authors:
1.
Moscow Technical of Communications and Informatics
(Department of Informatics, Associate professor)
employee from 01.01.2006 to 01.01.2022
Dedovsk, Russian Federation
employee from 01.01.2006 to 01.01.2022
Dedovsk, Russian Federation
Type:
Study guides
ISBN:
978-5-16-013667-7
ISBN-online:
978-5-16-106329-3
Status:
In work
Language:
Russian
Quantity of pages:
317
Publisher:
INFRA-M Academic Publishing LLC.
Abstract (English):
The tutorial discusses the basics of algorithmization and programming in Visual Basic for Applications (VBA), describes the action of linear, branching and cyclic structures. Much attention is paid to programming based on functions and procedures, processing one-dimensional and two-dimensional arrays, working with files. Examples of mathematical data processing, the use of spreadsheets for charting are given. In addition, the methods of creating macros, the principles of developing test programs based on various controls are considered. At the end of each Chapter there is a set of control questions and tasks. It has an applied orientation and meets the requirements of the Federal state educational standards of higher education of the last generation. It is intended for students of higher educational institutions studying under the programs of bachelor of technical specialties, it will also be useful for students of secondary professional educational institutions and schoolchildren in preparation for the Unified state exam on the discipline "Informatics and ICT".
The tutorial discusses the basics of algorithmization and programming in Visual Basic for Applications (VBA), describes the action of linear, branching and cyclic structures. Much attention is paid to programming based on functions and procedures, processing one-dimensional and two-dimensional arrays, working with files. Examples of mathematical data processing, the use of spreadsheets for charting are given. In addition, the methods of creating macros, the principles of developing test programs based on various controls are considered. At the end of each Chapter there is a set of control questions and tasks. It has an applied orientation and meets the requirements of the Federal state educational standards of higher education of the last generation. It is intended for students of higher educational institutions studying under the programs of bachelor of technical specialties, it will also be useful for students of secondary professional educational institutions and schoolchildren in preparation for the Unified state exam on the discipline "Informatics and ICT".
