Process automation with VBA
I started this repository in order to create reusable code in VBA.
Notes:
- The codes were written to be used in a general way, that is, requiring few adjustments to execute such functionalities;
- The files above have a description of their function in the title (in English) and in the commits in Portuguese;
- The codes are written in English but the comments are in Portuguese for better understanding;
Use:
- open excel and enable the "Developer" tab in: Files -> Options -> Customize Ribbon -> then in "Main Tabs" flag the "Developer";
- The files here on Github are in (.bas) format, but to place them in Excel, follow the instructions below;
- Just copy the code and paste it into the Excel code editor ("Developer" tab -> "Visual Basic") and then save the file with the extension (.xlsm);
- In the code below the "--input" comment are the codes where the requested information must be inserted, in order to run VBA in the correct place in the spreadsheet.
