How to change Product Key for Office 2013 Home and Business

The small company I support bought 5 computers and each comes with a product key for the Microsoft Office 2013 Home and Business. For some reason,  I put a same key for the second Office installation. And I didn’t find out till the activation process gave me the error indicating that the same product key has been activated in some place else. Continue reading

Resolved the “Critical Disk Error” Malware

Critical ErrorA friend called that he opened a Microsoft Word file from an unknown sender, and clicked the “Enable Macro” security option, and then his computer stopped working with the following error message window prompted.

Windows has encountered a corrupted folder on your hard drive.

Multiple corrupted files have been found in the folder “My Documents”. To prevent serious loss of data, please allow Windows to restore these files.

And there are two “Restore files” and “Restore files and check disk for errors” link at the bottom. My friend did not believe these messages were legitimate ones from Microsoft and suspected that his computer was infected by some kind of virus / malware. So he didn’t go ahead to click any of these two links and gave me a call. I am glad he did since who knows what would happen if he clicked them.  Continue reading

Not receive order notification in CS-Cart

Tested the CS-Cart check out function, everything went well when I placed a order myself. And I also received an email from the system with the order information. But the email I used as the orders department did not receive the order notification from CS-Cart.

I spent (and wasted) a lot of time to do the trouble shooting on the issue above. Even I contacted the host provider to see if the email system blocked the emails generated from the CS-Cart code. But the solution actually was simply as the below.

Go to the back-end admin control panel of CS-Cart, click the “Orders” top menu item and then “Order Statuses“. On the new page, click “Edit” or click the “Open” status directly, and check the “Notify orders department” on the next Open Status page.

That is it.

How to enable ratings/comments on all products in CS-Cart

I compared a lot of shopping cart systems, and finally settled down with CS-Cart. If I have time (I wish) I would like to write down some of my comparison of these e-commerce system (Free Open Source ones and paid one). But even with CS-Cart which is not perfect, I had to do some extra work to get it work in the way we need. Today I just wanted to share one of tips I found to do something CS-Cart doesn’t have by default.

In CS-Cart, the review/comments addon has not been enabled by default. So you either do it one by one, or do it in a mass editing way as the below. Continue reading

How to change permission on all files in a folder and its subdirectories in Linux OS

Today I got a call to be notified that a Joomla-powered website went down. The error message is the core file could not be opened due to permission. I checked the file system and found all PHP files had been changed permission as 200 (User Write only). I don’t know why caused it, but I believe it did something with the mal-ware alerted by Google Webmaster tool yesterday.

Continue reading

How to set Microsoft Excel cell background color in VBA

Recently I have been working on a VBA project, so I will post some skills or tips I learned and used on Excel VBA program. Today I will share how to change the cell background color in the VBA module.

The property of background color is , and the color is used as Index format. So to setup a cell (row ID: 1, column ID: 12) in Red background color is the below:

Worksheets(1).Cells(1,12).Interior.ColorIndex = 3 ‘change the background color to RED

And you can find more color index in the rest of my post. Continue reading