Analysis of automation of tasks through computer programming in VBA: What are the benefits of it?

Nowadays we are living in a world which is in a continuous change, where the technology is constantly advancing, faster than in other eras of the humanity. In other words, we are entering in the Fourth Industrial Revolution or Industry 4.0. “Industry 4.0 can be defined as the incorporation and management of intelligent products in the realm of physical processes, management, and information/digital”. (Bernardo Nicoletti, 2020) So, the humanity is in the brink of welcoming a new industrial revolution and the advancements made by the previous revolutions taught us that this new revolution will also make our lives much easier and comfortable as it has never been before. (Thich Duc Thien, 2019) That is why many companies around the world are excited about their digital transformation initiatives, trying to transform its business into the digital world. Some are developing their own applications, digitalizing their business model, also executing a new digital commerce strategy. (Marius Leibold,2018) Like other companies, the company Accredia (an Italian company) wanted to automatize some of their processes through the computer programming. The Departamento di Taratura from the company looked for a programmer who was able to automatize some tasks through a little software developed in VBA. So, this work describes the process through this program was developed step by step. This work will start defining some concepts that are important to know before start talking about the preparation of the program, then the company will be presented with the department who has commissioned this project and the way how the progress was shown. Also, the old method that the company wants to automatize and the failures that we have found about it will be exposed (reasons why the company wants to automatize the process), and then the explanation how the program was developed step by step with a deep conceptual explanation in the most important parts with literary references to help in the illustration of this process. After an explanation how the program was realized, the thesis will explain how the variables of the program must be setting up to guarantee the correct functionality of it by the future user. Then an analysis of the program and an important comparison between both methods will be developed to see which of them is considered better in this job and why. So, the advantages of this automation will be shown and clearly the disadvantages of the previous method will be exposed to see which of these disadvantages have been overcome by the automation. At the end there will be a conclusion of the job developed to understand better the advantages of this new digital method over the previous one. Also, new improvements over this new method will be analyzed to see if this program could be more independent from the human intervention (if the company wants to continue improving the automation degree). Keywords: Automation, VBA, Digital, Software, Programming