When Excel will not convert a date to a date
While working with several CSV files, I found myself in a strange situation. I had merged the file contents into a single CSV file. I then opened the file in Excel, only to find that the Date column had data that was a mix of YYYY-MM-DD and MM/DD/YYYY. There are several things that can cause...
List all Active Directory Groups for users in an Active Directory group
The following PowerShell script finds all of the Active Directory group memberships for users in a target Active Directory Group. All you need to provide is the target Active Directory group, and the script does the rest.
Remote Desktop won’t go back to Full Screen Part 2
Learn how to use AutoHotKey to resize your remote desktop sessions back to full screen after minimization in Windows. Never deal with scroll bars in RDP again!
Working with Seconds in Excel
I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
Remote Desktop won’t go back to Full Screen after Minimization in Windows 7
Learn how to get your remote desktop back to full screen after Minimization
Using Windows Media Center on a Dual Screen Setup with Windows 7 x64
If your PC came with Windows 7, chances are you already have Windows Media Center installed. Some PCs come with a built in TV tuner, or you can get an external TV tuner at a reasonable price at your favorite store. One of the neat things about having a TV tuner on your machine is...
Unshare Folders in Windows 7
I was formatting the several of my machines the other day and I was moving files back and forth. Sure, for MP3s or videos, I use an external USB hard drive. But there are smaller files, such as the Adobe Flash installer or Opera, which are pretty small. For those smaller files, I use a...
Could not install the custom actions
Learn how to fix the error "Could not install the custom actions" message
