Back office automation tools using Visual Basic for Applications in Microsoft Excel

Brotons Gutiérrez, Federico; Gallardo Campos, Pau; Garriga Turró, Gerard; Gómez-Rico Pérez, Pau

Back office automation tools using Visual Basic for Applications in Microsoft Excel

License

Citation

Brotons Gutiérrez, F, Gallardo Campos, P, Garriga Turró, G, Gómez-Rico Pérez, P. Back office automation tools using Visual Basic for Applications in Microsoft Excel. 2019. handle: http://hdl.handle.net/10230/41978

This citation was generated automatically.

Abstract

Large companies are starting to treat automation as a high-priority initiative to be implemented during the upcoming years. Yet, while great strides have been made in applying workplace technologies, it is argued that small businesses face more difficulties than big firms when it comes to a change in their operating system, as well as to exploit the returns to scale. This paper aims to demonstrate that Small and Medium Enterprises can also benefit from automation. Using Visual Basic for Applications, we created a program to automate certain tasks of an existent firm. In this way, we provide evidence that smaller firms could take advantage of a simple and feasible automation of processes.

Description

Treball de Fi de Grau en Administració i Direcció d'Empreses. Curs 2018-2019
Treball de Fi de Grau en Economia. Curs 2018-2019
Tutor: Ernest Solé Udina