In my last post about how to append or prepend text to data in a cell, Larry asked how one might be able to display the modified date of an excel file. This tutorial will explain the most efficient way to display the modified date of the file you are working on in a cell. Get Ready For Macros Getting right to it, the modified date of an excel file exists, but it isn't accessible via any of the functions that Excel has created for us. Instead, we'll create our own function in the Visual Basic … [Read more...]
Append or prepend text to the current date in MS Excel
December 18, 2012 by 4 Comments
Appending or prepending something is called concatenating in Excel. Concatenating is a big word for combining things in one cell. You could be trying to combine text and data, or two types of data, or two cells of text\data together into one cell. We'll be discussing how to concatenate text with date data. How to add text before or after a function in the same cell: Let's produce today's date in an cell. For that, we'll use the following function: =TODAY() Alone, this will produce … [Read more...]
Recover a Mailbox in Exchange 2010
September 20, 2012 by 3 Comments
Here are some things you'll need, for sure, before you get started: Access to the Exchange Server A backup of the exchange database (.edb) file and its logs The name of the mailbox you wish to recover and a second mailbox in case you'd like to copy data from the recovered mailbox to a random mailbox so you don't overwrite anything Here are the steps to the recovery: Add the Exchange Database to the Exchange Server as a "Recovery Database" Correct an issues with the database, … [Read more...]
MS Office Spell Checker Not Working
December 7, 2011 by Leave a Comment
No red underline while typing words incorrectly? If you upgraded Outlook to version 2010 but left the rest of your Office products at 2007, you may not be getting red underlines when you type words incorrectly in Outlook. Here's the easy, easy fix for this: Find the winword.exe file for Office 2007, located by default in C:\Program Files\Microsoft Office\Office12 (C:\Program Files (x86)\Microsoft Office\Office12 if you’re using 64bit). Copy and Paste winword.exe into Office 2010's … [Read more...]