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

How to remove page header and footer while printing in Firefox browser

When I printed some web pages in Firefox, I got these default header and footer information such as Page Title, Page URL on my print-out. In Firefox, there is not any interface for us to turn off or remove these page header and footer.

To remove, you need to change the settings in the its config page. Just follow the steps below:

  1. Type about:config in the address bar of Firefox;
  2. Click I am careful, I promise to enter into config page;
  3. Type “header” or “footer” in search field to filter all setting related to the page header and footer;For example, you will find something like “print.print_headerright” etc.
  4. Change the value of these print-header keys from something like “&T” to empty or “”; (remember these values in case you need to put back)

You are done, good luck.

A good WordPress plug-in recommended

bestwebsoftI should have written this post earlier since I have been using this plug-in for a while. But I didn’t realize its helpful result till recently I checked my comments section in my blogs.

As a lot of bloggers/WordPress Owners on the Internet, I put the comment spammers at the top of our hate list. I had to spend a lot of time to clean up these junk comments (with ads, links) even my WordPress installed the Akismet plug-in by default.

Things changed after I searched and installed a good CAPTCHA plugin from Bestwebsoft’s developer.  The following is what the plug-in description says about itself.

Plugin Captcha intended to prove that the visitor is a human being and not a spam robot. Plugin asks the visitor to answer a math question.

Well, I didn’t test and use other WordPress CAPTCHA plug-ins, so I couldn’t have a good comparison on it. And only thing here I have to say: it works, and works well for me. In the past month, I only had one or two junk comments on all my blogs compared to a few hundreds before without it.

If you are interested, and want to give it a try too. Search BWS CAPTCHA plugin in WordPress plug-in installation directory; or browse its website http://bestwebsoft.com/plugin/. Good luck.

How to get rid of newsletter required error in PrestaShop customer account registration

PrestaShopI used Prestashop for one of my friends e-commerce website. I tested, and everything was okay. But we didn’t like the Required message for the Newsletter checkbox while we tried to register a new account during the checkout.

So we tried to remove the required field. As usual, I searched the Internet for the solutions first. But a lot of search results talking about how to add new required fields for PrestaShop, like the phone number, etc. This needs to hack the Address.php class file. But I didn’t see any answers to my original question: just get rid of the Newsletter required message. Even I did, I would not have considered to do so by hacking the eCommerce system’s core files.

Then I looked up in the modules section, and I tried the different “newsletter” related modules. But unfortunately I still could not find a solution.

Finally, before I almost give up and decided to hack the core files, I found the place to make the change. Here is the how-to:

1, Log into the admin back-up.

2, select the Customers option from the Customers top navigation menu;

3, Click “+Set required fields for this section” button, and you will see “Newsletter” field overthere.

4, Un-check “newsletter” and click “Save” button below to apply your change.

And you are done, didn’t realize it was so easy and it was hidden there.