Visual Basic for Applications Automation Library Simple-VBA-functions


I created a GitHub Repository with my personal Visual Basic for Applicatios (VBA) Automation Library I used for automation for most of my excel reports while I was working as Reporting Specialist. At this point all the functions are enclosed in a single libSimpleVBAFunc.bas file and they can be included to every automation project. The repository includes examples folder that contains very simple examples with the use of libSimpleVBAFunc.bas functions. Link to the Repository: https://github.com/VelinGeorgiev/Simple-VBA-functions Everyone is welcome to contribute to this repository! What values could bring you this? 1. Less time in coding 2. Unified common functions that may make some macros easy to read. I recommend you to take a look at the examples, because they can give you some good overview. If you are interested in full excel reporting automation (by using Simple-VBA-functions library and Windows Task Scheduler) you may want to visit my this post: http://velingeorgiev.pro/automated-excel-report-task-scheduler-and-simple-vba-functions I have created below a brief manual on how include Simple-VBA-functions into your automation excel project. 1. Download the zip or tar.gz from GitHub: https://github.com/VelinGeorgiev/Simple-VBA-functions Velin Georgiev blog image 2. Open a new excel workbook. Velin Georgiev blog image 3. Use keys Alt+F11 on your keyboard to open the VBA Editor or you may use the developer tab visual basic editor icon. Velin Georgiev blog image 4. In the VBA editor go to menu File(Alt+F) / Import File... select the downloaded libSimpleVBAFunc.bas Velin Georgiev blog imageVelin Georgiev blog image 5. A new module "Module1" should appear in the project browser. Velin Georgiev blog image 6. Select Module1 and go to menu "View" Properties Window Velin Georgiev blog image 7. Then in the properties window rename the module from "Module1" to "SimpleVBAfunctions" for example. Velin Georgiev blog imageVelin Georgiev blog image 8. Insert a new module and rename it to "Main" for example. Velin Georgiev blog imageVelin Georgiev blog image 9. You are ready to start using the functions from the Simple-VBA-functions. For a quick test a below code can be added to the Main sub and executed. Velin Georgiev blog image 10. The function NewLog() creates a new workbook sheet named "Log" with three columns "Date","Time" and "Log"; The function Log("Hello World!") appends the text "Hello World!" to the newly created log. Velin Georgiev blog image Cheers Available on Github
Posted on

Tags: VBA, Excel, Visual Basic for Applications, Macro, Excel Functions

Comments