A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.
Just like me, you write Excel macros and you want a simple way to export your code as text files to your hard disk so that you can manage versions and load the code into e. g. GitHub? My vba_excel_export_code script is made for you. From now on it also manages the export of your ribbon.
Este proyecto permite realizar combinaciones de correspondencia avanzadas con Microsoft Word, donde el usuario puede elegir que se generen pdfs, que se firmen, que cada documento tenga un nombre específico y que se envíen por correo.
Version control within git for Excel VBA and customUI XML. Automatically export VBA & XML (and add them to the commit) when you commit an Excel file to github with this pre-commit hook!
Visual Basic Applications (VBA) modules written by myself (or credited to others in-comment) to increase the speed and accuracy of data cleansing/manipulation and office tasks in Excel
VBA functions to allow storage, retrieval and changing of an encrypted password within excel. Used in conjuction with excel's protect feature to design protected features or priviliges.