Office Solutions

How to Fix Dates in Your Excel Worksheet with VBA

How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". The xlsm in this exercise can be downloaded here. Not Our Problem! The...

Read more »

What to Do if You Get “Not Enough Memory” Error when Adding a Field via Access Design View

How many times have you tried to add a new field to an existing table and had the dreaded "not enough memory to complete this operation" error message? If the answer is none then you’ve been lucky – so far, but chances are that you'll have it at some point, so this article will explain how you can add a new field – even when Access doesn't think it can… Table changes – without the headaches I've lost count of the number of times I've tried to make a change to a table, whether it's...

Read more »

3 Key Thoughts for Anti-spam Strategies in Your Exchange Server

In this article we look at several aspects related to creating a macro strategy for dealing with spam emails in Ms Exchange. Applying anti-spam techniques to MS Exchange might seem like something that does not have to be thought upon much. This is however one of the very common misconceptions held by Exchange users. As important it is to protect your mailbox server from spam and junk mail, equally important it is to strategize the protection method. You do not just have to simply apply the...

Read more »