Category: Applications

This post is about a common business problem of grabbing messy data from a transactional document and updating a dataset to collect history.  In my previous life, I was in Commodity Export Marketing, so I am using the ‘real world’ …

Grabbing messy data with VBA Arrays Read More »

Tagged with: , , , , ,

OK so this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system.  See here for Part A.  This example concerns automating entries on your bank statement you can reliably identify.  …

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »

Tagged with: , ,

If your application needs to print dynamic reports, then ideally to save tedious manual print setup, you need a print macro. If your application needs to print several dynamic reports it’s even better to have one versatile print routine that …

Re-usable Print Macro Read More »

Tagged with: , , , ,

This post is about monitoring the workbook environment when working on key workbooks or workbook applications especially if they involve VBA, which is my approach to developing key workbooks for clients.  You wouldn’t do this for an ad hoc or …

Monitoring the Workbook Environment Read More »

Tagged with: , , , , , , , , ,