Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

How To Export Excel Spreadsheet To A Fixed-Width Text File

September 4, 2013January 24, 2023 Kent ChenTips & Tricks

The easy way is to Save As to a Formatted Text file (Space Delimited)(*.prn). But you will be struggled to find out that it’s really hard to precisely specify the fixed-width, almost impossible to use to export the data into a perfect space aligned text file. What I am luck to find out is this with VBA. It’s a far […]

Read more

Connecting to SQL Server via Management Studio

May 14, 2013January 24, 2023 Kent ChenMicrosoft

I just can’t remember how many times I’ve seen this same error popping out to me when I was trying to connect to a new SQL server. And every time when I see this I had to dig into my mind figuring out what to do to solve this. So it’s time to jog down the notes for the next […]

Read more

The Secret of Junk Genie

November 28, 2012January 24, 2023 Kent ChenMusing

Go to 1-800-Got-Junk’s website and take look its smarty Junk Genie. Take a ride if you may. Done? and amazed? Is it really that smart? The sneaky Junk Genie pretends to be smart by taking great advantage of the magic number 9. Take a close look at the steps you have to take: 1. thinking of a number of 2 […]

Read more

Enable Audio Redirection on Windows Server 2008 Remote Desktop Session

July 24, 2012January 24, 2023 Kent ChenMicrosoft

A user complained that he couldn’t listen to the wav file from his Outlook when he’s on Remote Server. I logged into the server and noticed that there is a red X mark showing on top of the speaker icon on the system tray, indicating that there is no audio output device installed on the server. Because this is a […]

Read more

How to deleted a folder named with spaces

March 21, 2012January 24, 2023 Kent ChenTips & Tricks

I had a folder on the network named just with a few spaces and I had a heck of difficult time trying to delete it. When I tried to delete it from Windows Explorer, I got message saying that Cannot delete file: cannot read from the source file or disk And when I tried to rename, or copy & paste, […]

Read more

The computer system explained in your washroom

March 20, 2012January 24, 2023 Kent ChenMusing

I was laughing so hard especially when I saw that Backup System and the User Interface in that system. How similar, if not exactly the same.

Read more

How to repair a corrupted Excel spreadsheet

March 15, 2012January 24, 2023 Kent ChenTips & Tricks

I store all my documentations in my Dropbox so I can get access to them at anytime from anywhere. But this morning I found that one of the excel sheet I have in the Dropbox corrupted. And because it’s in the Dropbox, the corrupted version was on every single device I have Dropbox installed. Ooops, even on the Dropbox web […]

Read more

A good list of free add-ons to make your Outlook better and more efficient

March 14, 2012January 24, 2023 Kent ChenMicrosoft

If you use Outlook you have reason to rejoice, because there is a wide range of free add-ons that greatly enhance Outlook’s functionality and add considerably to it’s user experience. Here comes a list of them that are free and useful. Tip my hat to FreewareGenius for making a good list of them here and here. Note that all add-ons […]

Read more

Posts navigation

Older posts
Newer posts
  • Group Policy to Bypass the UAC Prompt After PrinterNightmare Patch
  • Managing Microsoft Licenses in PowerShell and Microsoft Graph
  • Audit Email Deletion in Microsoft 365
  • Adding Multiple Server Names to A Windows Server
  • Enforcing HTTP to HTTPS on IIS

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.
KC's Blog
Proudly powered by WordPress Theme: Astrid.