Excel VBA Tool for a Large Corporation

Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code rows. Complex Excel ribbon tabs and VBA forms created, progress bars used Multiple VBA procedures created: to open template files, to migrate data from older versions, to import and clean data from excel files, to perform complex calculations, to refresh pivot tables, to build matrix d...
Read More

Excel tool to parse OCRed PDFs

Excel VBA tool to parse multiple large OCRed PDF documents into CSV files. SQL queries used to get data from source files fast and  w/o opening the files in Excel. Regular Expressions used to split data into rows and columns, to verify data formats, to remove trash characters, to fix OCR errors. The tools is able to detect and fix multiple OCR errors or highlight and log record...
Read More