Close

January 28, 2015

A break from Word VBA .. and into Excel for mileage calculation

We have a staff handbook that we look after the updates of in work. Inside it is a large table of clients and the approximate mileages.  However, it needed a bit of an update, so I’ve found some code to automatically extract the mileage between two postcodes and display it in a cell.

So I’ll be knocking up a nice spreadsheet to bring both the raw data (extracted from Dynamics) into the spreadsheet and maybe add a simple GUI which will allow anyone using the spreadsheet to force a refresh of the data.

Makes a change doing some Excel VBA instead of the usual Word VBA 🙂


Fatal error: Uncaught Error: [] operator not supported for strings in /home/mikestoo/public_html/wp-content/themes/layerswp-master/core/helpers/post.php:62 Stack trace: #0 /home/mikestoo/public_html/wp-content/themes/layerswp-master/partials/content-single.php(79): layers_post_meta(178) #1 /home/mikestoo/public_html/wp-includes/template.php(724): require('/home/mikestoo/...') #2 /home/mikestoo/public_html/wp-includes/template.php(671): load_template('/home/mikestoo/...', false) #3 /home/mikestoo/public_html/wp-includes/general-template.php(168): locate_template(Array, true, false) #4 /home/mikestoo/public_html/wp-content/themes/layerswp-master/single.php(20): get_template_part('partials/conten...', 'single') #5 /home/mikestoo/public_html/wp-includes/template-loader.php(78): include('/home/mikestoo/...') #6 /home/mikestoo/public_html/wp-blog-header.php(19): require_once('/home/mikestoo/...') #7 /home/mikestoo/public_html/index.php(17): require('/home/mikestoo/...') #8 {main} thrown in /home/mikestoo/public_html/wp-content/themes/layerswp-master/core/helpers/post.php on line 62