Pages

Tuesday, July 17, 2012

Show Developer Tab in Excel 2010



To be able to use Macros or VBA in Excel 2010, you should access the Developer tab. This tab allows you to record Macros, create form controls, view XML source, etc.

To show the Developer tab in Excel 2010, follow the instructions below:
  1. Go to File > Options.
  2. On the Options window, click Customize Ribbons from its left menu.
  3. On the Customize Ribbons panel, select Main Tab, and tick the Developer checkbox as seen on the image: 
  4. Click OK to apply changes.
After these, Developer tab should already be available.



Sunday, May 27, 2012

Unable to create a constant value of type 'System.Object'. Only primitive types ('such as Int32, String, and Guid') are supported in this context

If you are working on LINQ Query with JOINS, one of the reasons could be because you are trying to join them directly without involving the primary entity.

Friday, April 2, 2010

Host process for windows services stopped working

Install Windows Update KB980182 applicable to your OS.