Posts
-
Faster than a speeding byte
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...
-
Taking control of cloud billing
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 its possibilities...
-
How to tell if a file is a Word document
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...
-
Handling strings containing quotes in SQL
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...
-
Understanding the INDIRECT function in Excel
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...
-
Microsoft Project holiday import wizard
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 public holidays as...
-
Error in Excel 2007 workbooks open method
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 protection” password...
subscribe via RSS