Excel sheets protection

Excel sheets are mostly used for reporting purposes and reports mostly 
based on confidential data, so security is very important for Excel 
based reports. 

Here is the code in visual studio to protect the excel sheet 

 1) Open vb console application and add this code

Module Module1

    Sub Main()


        
        Dim strfilename As String = "c:\dwreport.xls"
        
        Dim strnewfilename As String = "c:\protectedhehadwreport.xls"

        Dim strPassword As String = "yourpassword"

       
        Dim objExcel As New Microsoft.Office.Interop.Excel.Application

        Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook

        objWorkbook = objExcel.Workbooks.Open(strFilename)

        objExcel.DisplayAlerts = False

        objWorkbook.SaveAs(strnewfilename, Password:=strPassword)

        objWorkbook.Close()

        objExcel = Nothing

        Return

   
    End Sub

End Module

2) Go to project, add references and add microsoft excel libraries from .COM

Infographics and SEO

There are many reasons why infographics could be good to market your content.
 The Audience can quickly grasp loads of information and they don’t have to engage in long pictureless descriptions.
Nothing makes it faster to get the point than a picture. Almost everything can be made into infographics no matter how technical it may be. There are lots of possibilities that you can explore by using them on your website.
 The graphics are more memorable than chunk of text.
The first written languages were picture languages. Homo sapiens has a deeply embedded picture recognition and memorising mechanism that so far nothing else can beat it.
 Your infographic can be easily reposted therefore you get a link to your site which is good for your SEO!
Because the infographic can be embedded, it is really easy to attract more people who want to share it on their own blog. It is more likely that you get a relevant link as well.
If your infographic is well designed people are more likely to share it, so you get more traffic.
The number one shared media is pictures so you can’t go wrong with it!
Infographic is more likely to go viral.
Great posts cause great attention but Infographics cause a lot of attention in the first place so you get the double chance to go viral.
 By breaking down the topic in graphics you can make your content to be more easily accessible to people who do not know the subject much.
This is probably the greatest feature of infographics. The information can be designed in such an apprehensive way that you can instantly turn anyone into a person who knows and can engage with the key points in the subject area.
They can  be shared easily through social sites such as Facebook, Twitter, Digg, Reddit, StumbleUpon and more. 

To increase the length of username in orangehrm

To increase the length of username in orangehrm
C:\xampp\htdocs\orangehrm-3.0.1\symfony\plugins\orangehrmAdminPlugin\lib\form\systemuserform.php is edited for increased length

D:\xampp\htdocs\orangehrm-3.0.1\symfony\web\webres_513fd0981da216.38969927\orangehrmAdminPlugin\js\systemusersuccess.js

edit for more length

C:\xampp\htdocs\orangehrm-3.0.1\symfony\plugins\orangehrmLeavePlugin\modules\leave\templates\mail\en_US\apply

change the mail format