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

Printable Interactive Excel Form

Printable interactive order form with add row, remove row and reset functionality. Just in one click user can add/remove rows in different sections of the form. As well as reset button will remove all added rows. User can use either buttons (visible but non printable) on the form or buttons on the ribbon. All values inputted into user added rows automatically included into calc...
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

Converting PDF files to Excel

We convert scanned and searchable PDF files to excel. We prefer to use VBA programming and advanced custom excel functions to do pdf to excel converting job fast and with 100% accuracy. If you have 1000 pages pdf document (with similar structure of all pages) we will just create a program to process first page and then we will be able to process all document in one click. No ma...
Read More

Advanced Excel Formulas to Split Names, Addresses and Phones

We use advanced excel formulas with custom vba programmed functions to split string data into columns. For example to split string with names and phones to First Name, Last Name and Phone columns: [swf:http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf 595 359] http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf Advanced excel formulas also can be used to split addre...
Read More