Office File Recovery

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 »

4 Easy Tips to Change the Color of Comment Balloons or Texts in Your Word Document

In this article, there are 4 easy tips for you to change the color of comment balloons or texts in your Word document. By and large, the color of comment balloons in document is randomly assigned by Word according to the editing author. Similarly, the comment text color is by default set in black. Nevertheless, we still can apply some tricks to change the default color. Tip 1: Apply Custom Color for Comment Balloons It’s a popular knowledge that Word distributes color to comment balloons...

Read more »