There are a number of reasons why an Australian cloud server can be better for you than an offshore equivalent. However, latency is easily one of the most popular. So how much of a difference can i...

Originally published when I worked at Ninefold, an Australian cloud services provider I co-founded, that operated from 2010 - 2015. At Ninefold, we first started looking at the cloud market and i...

I am building a tool that needs to do something to all the Word documents in a set of folders. There are other sorts of files in these folders so I need to filter the list. I didn’t want to hard co...

Everyone is aware that quotes in strings used in SQL cause all sorts of problems. As developers, it is our duty to ensure that an end user never sees an SQL error because we didn’t handle his input...

This is not a VBA issue but a recent discussion on LinkedIn brought up the question of how to use INDIRECT to construct a reference to a named range in an external sheet. I have been using this ver...

Check out this VBA enabled Microsoft Project Plan document that I recently developed. It neatly solves a need of every project manager who uses Microsoft Project to track their project: marking pub...

I have discovered a disturbing “feature” in Excel 2007 VBA in the way that the Workbooks.Open method handles xlsx format files versus the legacy xls format file. If a file has a “workbook protecti...