Notice: The called constructor method for WP_Widget in collapsCatWidget is deprecated since version 4.3.0! Use
instead. in /var/www/vhosts/121/242034/webspace/siteapps/WordPress-56954/htdocs/wp-includes/functions.php on line 4718
Excel - Macros and VBA | Brendan Moran

↑ Return to Excel Spreadsheets

Excel — Macros and VBA

I devel­op macros and VBA rou­tines for organ­i­sa­tions that can quick­ly process your data and files.

In a recent project I was able to reduce the time tak­en to process 18 bank accounts from 8 hours down to 8 sec­onds.

This is a huge time saver for both you and your staff.

I can also update your exist­ing macros.

The raw data can come from:

  • Excel
  • SAP
  • Ora­cle
  • Oth­er Data­base Sys­tems

The data is then processed to pro­duce the rel­e­vant data for your needs.

This data can then be used in:

  • Mas­ter Excel file
  • Mul­ti­ple Excel files
  • Export­ed out to PDF, Excel or Word.
  • Data Min­ing
  • Inte­gra­tion of Microsoft Excel and Microsoft Access Data­base

This is all macro dri­ven using VBA.

Your month­ly rou­tines that might take days can be reduced to sec­onds !!!!!!