Technology Insights

Install Clear On Windows Using Cygwin, Use Clear To Reset Console Output

When I SSH to Linux servers I use the clear command a lot. This allows me to quickly reset the shell interface so there is no output so depending on if I have typed the incorrect command numerous times or the screen is filled without from something like the locate command I find it really useful to reset the interface so the screen is blank again without having to hit enter 50 times. On all of my Windows machines I have Cygwin installed to provide as much of a Linux feel as possible however I never have taken the time to figure out what installs the clear command so I could have the same luxury of clearing the windows Command Prompt or the Console2 application I use on a regular basis. Below I describe how to install clear on Windows using the Cygwin application.

Technology Insights

Microsoft Office Excel Keyboard Shortcut For Adding Hyperlink To A Cell

Earlier I was analyzing a bunch of data and needed to go through a couple hundred columns and fill out specific data in each column. One of the tasks I needed to complete was adding a URL to a single cell and once that URL was added to the cell I needed to then create a hyperlink for each specific cell to a configuration application that had specific data about each URL. Do complete this easier I needed a keyboard shortcut to initiate the hyperlink addition configuration window in Office Excel. Below I describe what the keyboard shortcut is and what it does.

Technology Insights

Outlook 2010 Add-In Error: Add-In Was Disabled By The User After A Data Execution Prevention Failure

I use an Outlook 2010 add-in called Bettasoft Mail Alert to display a mail icon in the task bar when new mail arrives. A couple of days ago the add-in caused an error and Outlook disabled it. I initially thought I could just go into the Options and put a check back into the add-in checkbox however that did not work. After more investigation I figured out that you have to enable the add-in in the Disabled Add-Ins window first and the put a check in the add-in check box for the disabled add-in to work again. Below I describe the error in more detail and the steps taken to resolve the error.