This work was born from the necessity found by the author to solve problems of various kinds during her studies and work. The large amount of data and the repetitive processing required an automated procedure that could be applied in any context. The author, being a programmer and being an expert in Pascal, Cobol and Javascript, searched for the most suitable solution and found it in the Excel VBA. This document is intended to introduce users to programming in general and to programming in Visual Basic for Applications and Excel in particular. VBA is simple and can be used on existing Excel files, quickly processing a large amount of data. The only tool we need is Excel.
The book may not contain everything you should know about programming in VBA, but it does point the finger at the key points to create some programs which are explained in the various chapters. The content is divided into two parts one which explains programming in general and the second which explains programming in VBA with concrete examples of programs. In this latest version, more complex electronic procedures have been added that process various Excel files at the same time that can be used for warehouse management, for the management of work orders, for the management of payrolls and in all those problems where it is necessary. create summary reports of input data in different files. Obviously we will not write all the possible examples because they are infinite,
The book may not contain everything you should know about programming in VBA, but it does point the finger at the key points to create some programs which are explained in the various chapters. The content is divided into two parts one which explains programming in general and the second which explains programming in VBA with concrete examples of programs. In this latest version, more complex electronic procedures have been added that process various Excel files at the same time that can be used for warehouse management, for the management of work orders, for the management of payrolls and in all those problems where it is necessary. create summary reports of input data in different files. Obviously we will not write all the possible examples because they are infinite,